Hi,
Would someone lend a hand with a join that has me confused.
Well actually, almost every join has me confused.
From the manual:
SELECT table1.* from table1
LEFT JOIN table2 ON table1.id=table2.id
where table2.id is NULL
selects from table 1 that which is not in table 2.
That's pretty neat.
It's a start on what I need, but I can't figure it out.
Can I select the item_names that player_name does not have,
but just fpr a particular player from the game table ?
game status player_names item_names
------- -------- ----------- -----------
player_id player_id player_id item_id
group item_id player_name item_name
game
location
(Players start with 500 items - no entries in the status table.
As they lose items, entries go into the status table..
As they gain items, entries come back out of the status table.)
Any ideas?? Help would be much appreciated
Thanks, Mark
-----------------------------------
Nude & Portrait Gallery
Art-Nude.com
--------------------------------------------------
