sql query trouble [message #2817] |
Wed, 14 August 2002 09:56 |
Heaven
Messages: 1 Registered: August 2002
|
Junior Member |
|
|
Hi i am having trouble getting my head around an sql query. The query:
"SELECT t.pub_name, tl.accountno
FROM tenant_login tl, tenants t
WHERE t.pub_name = '"+name+"' AND t.accountno = tl.accountno";
produces a list of pub names and account numbers when an account number exists both in tenant_login and tenants.
How do i create a query that lists the pubname and account numbers where the account number exists in tenants but NOT in tenant_login?
Thanks
|
|
|
Re: sql query trouble [message #2818 is a reply to message #2817] |
Wed, 14 August 2002 10:01 |
Keith
Messages: 88 Registered: March 2000
|
Member |
|
|
You need an outer join:
SELECT t.pub_name, tl.accountno
FROM tenant_login tl, tenants t
WHERE t.pub_name = '"+name+"'
AND t.accountno = tl.accountno(+)
|
|
|
|