Jump to content

Help selecting what is NOT in two tables


benphp

Recommended Posts

I have two tables:

 

Classes

CLID | CLDate

 

ClassDetail

CLID | Description | Instructor

 

 

I'm trying to figure out a single SQL statement that would return all CLIDs that exist in ClassDetail but NOT in Classes.

 

I'm in the process of fudging it in PHP, but I know there's a better way...

 

Thanks!

Link to comment
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.