Need A help

[Anon]

Hello
I have two table Like Bellow

First is Application Table which is like this

App_Id App_Name

1 Application1

2 Application2
3 Application3

Second is Customer Application Table which is like this

CustApp_Id Cust_Id App_Id
1 1 1

2 1 2
3 2 2

 Customer Application table is nothing but Application Assigned to Customer..
 I want query both these tables so that i can get all applications available to particular Customer.Remember this should not not include Applications assigned to the customer already..

 select A.App_Id,App_Name from ASP_Application A left join ASP_CustomerApplication B using (App_Id) where (B.Customer_ID !='"+Cust_Id+"' or B.Customer_ID is Null)

 But it shows me application Already assigned to customer..

 How i can filter this out.....

 i stucked here..

 pls help

 Milind

[vponz]

Try this:
Select * FROM ASP_Application
WHERE App_Id NOT IN (
SELECT App_Id FROM ASP_CustomerApplication
WHERE Customer_ID ="$Cust_Id")

Bye

[Anon]

You want to return the UNMATCHED rows only so use the WHERE clause to eliminate the matched rows. Specify customer_id in JOIN.

SELECT A.App_id, App_Name FROM ASP_CustomerApplication CA RIGHT OUTER JOIN ASP_Application A ON (CA.Customer_ID = $Cust_id AND CA.App_id = A.App_id) WHERE CA.App_id IS NULL