p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   problem with a query in orac le 8.1.7 (http://p2p.wrox.com/showthread.php?t=90538)

Barbi July 17th, 2013 01:12 AM

problem with a query in orac le 8.1.7
 
Hello,
I have to write a query in oracle 8.1.7
Normally in SQL it should look like this:

Select * from table1 t1
Left outer join table2 t2 on t2.a1=t1.b1 and (t2.a2=t1.b2 or t2.a3=t1.b3)

How would this look like in Oracle 8.1.7 because there is no left outer join there , mostly I am confused with the multiple conditions on the left outer join.

Thanks


All times are GMT -4. The time now is 04:01 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.