Help selecting values where if other table doesnt have values

[doublea2k7]

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.

[freelance84]

why not just put the status field in the table account?

 

You could also change the staus field to be 0 or 1, then just select all the status's = 1

 

seems more efficient from the info you've written