doublea2k7 0 Posted September 2, 2010 Share Posted September 2, 2010 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
freelance84 1 Posted September 3, 2010 Share Posted September 3, 2010 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 Link to post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.