I thought that I had this working yesterday but I did not. I have two tables (TabA, TabB). tabA has a list of courses with id, name and description. TabB has three columns: IndividualId, TabA_ID (from the TabA) and a description.'<BR><BR>I want to bring back all of the information from TabA except the ones that are entered into TabB.<BR><BR>For example, If Blue, Black, brown and pruple are in TabA and only Blue and Black are in tabB. Then I want to return Brown and purple.<BR><BR>I have altered my sql statement many different ways but cannot get the results I need. I haveno problem getting the results from TabA when they are present in TabB not when they are not.<BR><BR>If you have any ideas It would be greatly appreciaated. I am just stumped. I have tried joins and a bunch of different thiings. I thought that if I brought back all the reults for the ones that were present I would only have to change the equals to a not equals but that is not the case.<BR><BR>My SQL statement is:<BR><BR>"SELECT Distinct TabA.ID, TabA.Name, Taba.Description FROM TabA WHERE TabA.ID <> TabB.TabA_id AND IndividualID = '" & ID & "'"