Home » RDBMS Server » Server Administration » Re: Passthrough query
Re: Passthrough query [message #372554] Thu, 22 February 2001 03:18
John R
Messages: 156
Registered: March 2000
Senior Member
Sadly not.
An outer join in Oracle is done like this:

Table A has rows you want
Table B may have rows

SELECT *
FROM A,B
WHERE A.x = B.x(+)
AND A.date IS NOT NULL

The outer join marker is the (+) symbol.

Report message to a moderator

Previous Topic: 'Enter' pressed in textarea
Next Topic: Query retrieving
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 04:17:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.