[SOLVED] Can Anyone help me with a not equal query

[newbreed65]

Hi Everyone

 

In PhpMyAdmin I’m trying to get a list of clients from the clients table that don’t have any claims linked to them in the Claims table, I can get all the ones that have claims but don’t know how to get the ones that don’t have claims

 

Any Help?

 

Here are a few of my failed attempts

 

 

 

SELECT`Clients`.*, `Claims`.`ClientID`
FROM `Clients`
WHERE`Clients`.`ID`!=`Claims`.`ClientID`)


SELECT`Clients`.* 
FROM `Clients`
JOIN `Claims`
ON (`Clients`.`ID`!=`Claims`.`ClientID`)

[gizmola]

You need a LEFT OUTER JOIN.  Something like this may work

 

 

SELECT c.*
FROM Clients c LEFT JOIN (Claims cl)
ON (cl.ClientId = c.ID AND cl.ClientId IS NULL)

 

[newbreed65]

You need a LEFT OUTER JOIN.  Something like this may work

 

 

SELECT c.*
FROM Clients c LEFT JOIN (Claims cl)
ON (cl.ClientId = c.ID AND cl.ClientId IS NULL)

 

 

Thanx for that just before i looked on your post i tried the same thing and it look like its worked havent  double checked thou lol