I am embedding SQL queries in some VBA code. i need to create a recordset from one query and then write a second along the lines of
WHERE [Column] IN (recordset)
Ordinarily I would do a LEFT JOIN but in this instance i can't use that option. Is anyone aware of the correct syntax for this please?