Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

*= ? what does this mean

Status
Not open for further replies.
circleW

circleW

IS-IT--Management
Dec 30, 2004
1
US
Does anyone know what *= means in sql...never seen it before and can't figure it out...thanks
 
Sort by date Sort by votes
Specifically a LEFT OUTER JOIN but note that this way of specifying a join can give incorrect results in some situations.
 
Upvote 0 Downvote
By all means replace this with a correct outer join. YOu dod not want to mess with this sysntax as sometimes it will do a cross join instead of an outer join. It is very prone to incorrect results.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
189
JarlH
JarlH
Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
272
PHV
PHV
EarlStaley
  • Locked
  • Question
What Type of Table
Replies
1
Views
74
simian336
simian336
vengelus82
  • Locked
  • Question
Rescue this newbie
2
Replies
21
Views
209
vengelus82
vengelus82
CaptainKebab
  • Locked
  • Question
How can this be done?
Replies
1
Views
70
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top