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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-04 : 08:41:24
|
| R writes "SELECT PD1.UNITS_PAKD FROM PKT_DTL PD, PKT_DTL PD1, PKT_DTL PD2 WHERE PD1.PKT_CTRL_NBR (+)= 'MPN0940097' AND PD1.ASSORT_NBR (+)= '3A1/20100' AND PD1.ORIG_ORD_LINE_NBR (+)= PD.PKT_SEQ_NBR AND PD2.PKT_CTRL_NBR (+)= 'MPN0940097' AND PD2.SKU_ID (+)= PD.SKU_ID AND PD.PKT_CTRL_NBR = '3A1/20100' ORDER BY PD.PKT_SEQ_NBRI am not able to understand what this query actually does? An outer join with constatnt on right side, how does it help; as it will return all the rows of left tableAlso i want to implement this query as other syntax ( join...ON..), how can I write it in that format?Please help" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-04 : 10:46:47
|
| That doesn't look like code for Microsoft SQL Server.What DBMS are you using?CODO ERGO SUM |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-05-04 : 11:12:18
|
| That's oracle 8 outer join syntax. Possibly used by postgeSQL or ingress too. (just guessing) |
|
|
|
|
|
|
Sql- outer join on same table