Left Outer Join Question - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Left Outer Join Question

Author

Topic

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2009-06-24 : 11:47:16

SQL Server won't convert this query to Left Outer Join Syntax when I click 'Design Query in editor':

SELECT *
FROM Invoice i,
ClaimSubscription cs
WHERE
i.ClaimID *= cs.ClaimID
AND i.BillToID *= cs.BillToID

Any idea why it can't? Any idea what it would convert to?

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-06-24 : 12:30:49

Do you mean this?

SELECT * 
FROM Invoice i
LEFT JOIN ClaimSubscription cs
ON i.ClaimID *= cs.ClaimID
AND i.BillToID *= cs.BillToID

Some days you're the dog, and some days you're the fire hydrant.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-24 : 13:00:24

quote:
Originally posted by Skorch

Do you mean this?

SELECT *
FROM Invoice i
LEFT JOIN ClaimSubscription cs
ON i.ClaimID *= cs.ClaimID
AND i.BillToID *= cs.BillToID

Some days you're the dog, and some days you're the fire hydrant.

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-06-24 : 13:35:04

visakh, I was merely copying what the OP originally posted.

Some days you're the dog, and some days you're the fire hydrant.

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2009-06-24 : 13:57:25

quote:
Originally posted by Skorch

Do you mean this?

SELECT *
FROM Invoice i
LEFT JOIN ClaimSubscription cs
ON i.ClaimID *= cs.ClaimID
AND i.BillToID *= cs.BillToID

Some days you're the dog, and some days you're the fire hydrant.

Not really. The query you've got there is neither ANSI outer join operators nor non-ANSI outer join operators. I am trying to convert from non-ANSI outer join operators (ie. *=) TO ANSI outer join operators.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources