Posted by Marek on 12/09/05 17:00

Uzytkownik "Bruno Panetta" <bpanetta@gmail.com> napisal w wiadomosci
news:1134139168.642939.59140@g43g2000cwa.googlegroups.com...
> What is the meaning of *= in SQL?
> For example, what is the difference between the query
>
> select c.customernumber, o.amount , i.[description]
> from customers c, orders o, items i
> where c.customernumber = o.customernumber
> and o.itemnumber = i.itemnumber
>
> and
>
> select c.customernumber, o.amount , i.[description]
> from customers c, orders o, items i
> where c.customernumber *= o.customernumber
> and o.itemnumber *= i.itemnumber

*= is old fashioned "left outer join" clause.

MP

[Back to original message]