Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suman123
Starting Member
5 Posts |
 Posted - 2003-09-08 : 16:11:03
|
| Hey guys,Can someone show me an example of a left outer join joining one table to atleast 2 or 3 tables in SQL ?Any help is greatly appreciated !Thanks! |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-09-08 : 16:18:47
|
| Um, this is a SQL Server site.Jonathan{0} |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-08 : 16:50:03
|
| I guess you could post these in the OTHER category...SELECT * FROM myTable1 l, myTable2 r WHERE l.key = r.key(+)..Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-09-09 : 00:23:23
|
| go here:http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/state21b.htm#2065648-ec |
|
|
|
suman123
Starting Member
5 Posts |
Posted - 2003-09-09 : 13:25:32
|
| Hi guys,Thanks for all your help and suggestions, even though I know this is not an Oracle SQL forum. Thanks for your time ! |
|
|
|
|
|
|
Left Outer Join in Oracle