Re: Join questions

Rich wrote: > I have a couple fairly basic join questions I am hoping someone can answer. > I am familiar with other DB's but am new to Informix. Here are two queries > which I am trying to understand... > > 1) select ... from table1, table2, outer table3, outer table4 where ... > > Is the outer join a left or right outer join? Since there is no "on" > clause, how does Informix join the tables? Two right outer joins, from either table1 or table2 to each of table3 and table4. It's different again from anybody else's outer join. > 2) select ... from table1, inner loop join table2 on <condition> inner loop > join table3 on <condition> left outer join table4 on <condition> left outer > join table3 on <condition> I've not seen a loop join - are you using IDS or XPS? Are you sure that's valid syntax? > What is the difference between an inner join and an inner loop join? How do > the inner loop joins and left outer joins interact? Pass. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/