quote:

---

Originally posted by CoolEJ

Hi, I really need your help on this. I have two tables
Table A1 with columns RecordID1 and UserName.
Table B2 with columns Task1 and AppNames.

A user procedure creates a record from Table B2 to A1 by copying Task1 to RecordID1 and AppNames to UserName.

My problem is: How do I query for the AppNames that are not present in table A1.
It sounds simple, but I am having some problem getting the code right. By the way, only statements, that start with SELECT, are allowed by the system.
Please help me on this one.

Thanks in advance.

---

SELECT b.Task1,b.AppNames 
FROM B2 b
LEFT OUTER JOIN A1 a
ON a.UserName=b.AppNames
WHERE a.UserName IS NULL

quote:

---

Originally posted by CoolEJ

Hi Chirag, Thanks for the reply.
"Select 1 From A1 Where A1.RecorID1 = B2.Task1 And A1.UserName = B2.AppNames"

I tried to correct some parts:
SELECT B2.Task1 FROM A1, B2 WHERE A1,RecordID1=B2.Task1 AND A1.UserName=B2.AppNames
Please correct if I made it incorrect.

The result though did not bring any data.

---