ok try
SELECT
npc_faction.id,
npc_faction.name
FROM
npc_faction,npc_types
WHERE (npc_types.npc_faction_id=npc_faction.id)
AND npc_types.id is null
I'm wondering why you would check for 'is null' when the schema dissallows null entries in ncp_types.id
GeorgeS
|