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!

*= in SQL

Status
Not open for further replies.
fixthebug2003

fixthebug2003

Programmer
Oct 20, 2003
294
US
Hi,
What does the operator *= in SQL do?
Eg:select x,y,z from tab1,tab2 where tab1.a *= tab2.a

thanks
Fixthebug2003
 
Sort by date Sort by votes
It's an older syntax for specifying a LEFT OUTER JOIN in the WHERE clause. It is not supported in SQL-92 which requires that JOINS be specified in the FROM clause. Some DBMS systems continue to support it as an SQL extension.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
152
harfri
harfri
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
193
JarlH
JarlH
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
168
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top