Hi I have a query in memory which only has one column called Schedule_Guid.

I'm trying to query another collection where it's Schedule_Guid does not lay memory query.

What I've Tried:

select Schedules.Schedule_GUID INTO memory\m2 FROM Schedules
Join ScheduleScripts
On Schedules.Schedule_GUID = ScheduleScripts.Schedule_GUID
Where SubType_Id = 1000
Group By Schedules.Schedule_GUID;

Select * from Table where Table.Schedule_Guid not in memory\m2

Boss



Select * from Table where Table.Schedule_Guid not in (SELECT Schedule_GUID FROM memory\m2)


Roy Lambert