Re: Join Select

Aaaargh! Please contact the IIUG and ask them to sort this out, I shouldn't be getting these emails, but I'm getting one every few minutes, I think from anyone and everyone who posts a message to IIUG, i.e.: spam. Dom --- Hans Hansson <hans.hansson@kloster.se> 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> > Best Wishes, > Hans Hansson > > __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

Dominic Penfold wrote: > Aaaargh! Please contact the IIUG and ask them to sort > this out, I shouldn't be getting these emails, but I'm > getting one every few minutes, I think from anyone and > everyone who posts a message to IIUG, i.e.: spam. > > Dom > To de-list yourself from "informix-list@iiug.org", please use the appropriate instruction. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler Compile once, run everywhere Phoenix Windows GUI. Chimera Java GUI The only GUI you will ever need... Arachne Web Technology For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------