Join Select

In sql 7.0 i write the follow join syntax select * from table1,table2 where table1.cod =* table2.cod informix d'ont accept this syntax. i need write a equal select syntax in informix.

Jorge Manuel Silva Saraiva wrote: > In sql 7.0 i write the follow join syntax > > select * from table1,table2 where table1.cod =* table2.cod> > informix d'ont accept this syntax. > > i need write a equal select syntax in informix. Try this: select * from table1, outer table2 where table1.cod = table2.cod Best Wishes, Hans Hansson

Hans Hansson wrote: > Jorge Manuel Silva Saraiva wrote: > > > In sql 7.0 i write the follow join syntax > > > > select * from table1,table2 where table1.cod =* table2.cod> > > > informix d'ont accept this syntax. > > > > i need write a equal select syntax in informix. > > Try this: > > select * > from table1, outer table2 > where table1.cod = table2.cod Actually, I think it would be select * from table2, outer table1 where table2.cod = table1.cod SQLServer syntax =* is a right outer join. June -- june_t@hotmail.com Back from the dead, resuscitated by Godiva chocolates... Please do not send Informix questions to this account. I would add 'Please do not send spam to this account' but I suppose I would be wasting my bits.