Jump to content

Help selecting values where if other table doesnt have values


Recommended Posts

I have a table that holds user account info.


I have another table that holds status updates according to their account "id" in the account table.




|Table account|

id    Name    Last Name

1    Fred      John

2    Frank    Joe


|Table Status|

id    status            accountid

0      In Progress      1


How can would i select all the account ids that don't have any entries in the status table. So for the example above how would i select the account Frank Joe with id 2 as i has no status linked to it.

Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.