Home » RDBMS Server » Server Administration » Help for Query !!!!
Help for Query !!!! [message #373520] Fri, 20 April 2001 11:02 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hi,

Can someone please help me with this query:-

I have two tables 'SOP' and 'CLIENT' with "client_no" as the primary key. If I query on this two tables to find the joined records it retreives 3982 records. But in my SOP table I've 3988 records.

I need to find out which 6 client records from the SOP table are not linked to the Client table.

Please help!
Thanks!
Alpesh

Report message to a moderator

Re: Help for Query !!!! [message #373521 is a reply to message #373520] Fri, 20 April 2001 11:12 Go to previous message
aish74
Messages: 19
Registered: March 2001
Junior Member
Hi Try this

Select SOp.* from client,sop
where sop.client_no=client.client.no(+)
and client.client.no is null

Thanks,
Aish

Report message to a moderator

Previous Topic: how to display the initials ?
Next Topic: New jobs section - please post resumes and projects
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:06:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.