View Single Post
  #2  
Old 06-25-2006, 11:14 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote