[RESOLVED] Join issue, how can I do this?

[adamata]

OK, so I have a table with information about magazines.

fields: tkey, title, year, series, publisher

I have a table with user data

fields: ukey, title, year, series, publisher, own, need

I have it setup where the user will select a title from a drop down list I generate from the titles table. After selected, it inters a record in the user data table and allows them to enter own/need data. This is all good and working fine. No issues at all.

Here is where it gets tricky.

The next time the user goes to enter a new title into their data, I want to exclude the titles they have already entered.

IE in the titles table, I have TIME, LIFE, OMNI and National Geographic.

The user selects to enter a new record, chooses TIME and does his thing.

The next time the drop down is generated, I do NOT want them to see TIME.

I have tried a bunch o things )inner joins, outer joins, etc) but I either get all records or zero records

Any ideas?

Thanks!

[Piranha]

You should have a foreign key to the magazine table in the user data, to be able to make sure if you have done something or not. Then something like this should work:

SELECT whatever FROM mag WHERE id NOT IN (SELECT magid FROM user WHERE useid = $variable);

[adamata]

Doh! That worked perfectly. I just had been staring at it so long, I couldn't see it.

I added the extra field to the data table gets populated with the title ID when the new entry is made. Using that bit of SQL you gave worked perfectly.

Thanks so much!