Can this be done with a query?

[lurtnowski]

I have two tables (receptacles, power_trails)

I’m trying to figure out a query that would only result i the receptacle_id of any recepacle_id NOT in the power_trails table?

My thinking is I only want to see the receptacles without a power trail (meaning they are available)

[r937]

@lurtnowski

I’m trying to figure out a query that would only result i the receptacle_id of any recepacle_id NOT in the power_trails table?

SELECT whatever
  FROM receptacles
 WHERE NOT EXISTS
       ( SELECT 'whoops'
           FROM powertrails
          WHERE receptacle_id = receptacles.receptacle_id )

[lurtnowski]

thnnks