Trying to combine to queries using the union statement. I think for the most part that's working; however, now I am running into an issue using LIKE IN in a NOT IN subquery. Any thoughts?
SELECT tbl.tblfield, *
FROM tbl
WHERE tbl.tblfield In (select tbl.tblfield from tbl
where tbl.tblfield1 =...