SELECT query1.field1, query1.field2, query1.field3 FROM query1 WHERE field1 not in (#QuotedValueList(query2.field1)#)
I need to change that "WHERE" line to make this query run even if query2 is
null. It currently doesn't work if query2 is null.
how it is solve it give the solution of its