G
Guest
I need help with a query. In a table each id can have more than one
output_device, but must have at least an entry for 'RECS'. How can I identify
id's that don't have an entry where output_device = 'RECS'? Example, id of
567 is ok, but I want to get id 459 because it doesn't have an entry for RECS:
id output_device
567 RECS
567 IA3
459 IM7
459 TR4
Thanks for any ideas!
output_device, but must have at least an entry for 'RECS'. How can I identify
id's that don't have an entry where output_device = 'RECS'? Example, id of
567 is ok, but I want to get id 459 because it doesn't have an entry for RECS:
id output_device
567 RECS
567 IA3
459 IM7
459 TR4
Thanks for any ideas!