Home » RDBMS Server » Server Administration » Re: Finding Orphan Records
Re: Finding Orphan Records [message #373121] Wed, 28 March 2001 09:19
aish74
Messages: 19
Registered: March 2001
Junior Member
SELECT *
FROM table_B,table_a
where table_B.col=table_a.col(+)
and table_a.col1 is null

gives you the records which are not in table A(null)and exist in table B

Report message to a moderator

Previous Topic: the in clause
Next Topic: superscript
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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