Posted by Bruno Panetta on 12/09/05 16:39

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

The second one gives an error: "Query contains an outer-join request
that is not permitted", the first one runs ok.

Thanks,
Bruno

[Back to original message]