Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-05 : 09:48:02
|
| DOug writes "Hello...I have 2 tables jobs and job_notify They both have a common field of id.Jobs is always populated, but Job_notify is only populated if someone has applied for a job.I know how to do a join where I can get all the results from both tables(all jobs applied for and not applied for). SELECT jobs.company,jobs.title from jobs ,job_notify where jobs.id *=job_notify.id I can do a join where I only see results of jobs applied forSELECT jobs.company,jobs.title from jobs ,job_notify where jobs.id =job_notify.id But what I cant figure out is how to do a query on JOBS and then return only record that don't have an ID in job_notify)?Please advise Thanks" |
|
|
|
|
|
SQL JOIN issues