select using 2 different tables 1

[TGJ]

Hi, ok I have a bit of a problem. What I need to do is select info from table A only if that info is not in table B. Here is what I have:

SELECT DISTINCT A.TitleType
FROM organizationlots A, TitleCategory B
WHERE A.TitleType<>B.TitleType

This code selects all from Table A regardless of what is in Table B. Can someone help me?

Thanks,
Terry

 

[dalchri]

SELECT DISTINCT A.TitleType
FROM organizationlots A
LEFT JOIN TitleCategory B
ON A.TitleType = B.TitleType
WHERE B.TitleType Is Null

 

[TGJ]

Cool thanks!