Jump to content

Help selecting values where if other table doesnt have values


doublea2k7

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.

 

Example

 

|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

Archived

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.