SELECT Carrier FROM device WHERE Device_ID NOT IN (SELECT Device_ID FROM stock)
What are the carriers of devices that are not in stock anywhere?
SELECT Carrier FROM device WHERE Device_ID NOT IN ( SELECT Device_ID FROM stock )
select carrier from device where device_id not in ( select device_id from stock )
What are the carriers of devices that are not in stock anywhere ?