converting a query with *= into SQL 92

select a.col1,b.col2,c.col2
from tab1 a,tab2 b,tab3 c
where

a.col1 *= b.col1 and
a.col2 *= c.col2 and
b.col3 = c.col3

how do I write this query in SQL 92?

also can we replace *= with =* by interchanging the participating tables as in

"a.col1 *= b.col1" is this same as "b.col1 =* a.col1" Received on Wed Feb 04 2004 - 20:44:02 CET