Re: select in 3 Tables

On 27 Okt., 22:30, Art Kagel <art.ka...@gmail.com> wrote: > VERSION? > dbaccess -v DB-Access Version 7.25.UC6R1Software Serial Number AAA#B000000 isql -v IBM INFORMIX-SQL Version 7.32.UC4 Software Serial Number RDS#N000000 But I checked my syntax and saw that I forgot a comma "," before "OUTER" Now it runs I thougt there is a comma-Join "," , a OUTER JOIN, INNER JOIN, RIGHT JOIN, LEFT JOIN, and if I use OUTER JOIN, INNER JOIN, RIGHT JOIN, LEFT JOIN, I dont have to set "," befor it. I used this tutorial http://www.sql-und-xml.de/sql-tutorial/tabellen-verknuepfen-mit-join.html Hier is the right query that shows alle 1052 record Thanks all UNLOAD TO lieferantenstamm.csv DELIMITER ";" SELECT krd.knr, krd.nam, krd.tlf, krd.liefnr, zlb.bezeich1,lfb.bezeich FROM fyrkr1 krd, OUTER fyzlb zlb, OUTER fylfb lfb WHERE (krd.zahlbed=zlb.zahlbed) AND (krd.liefbed=lfb.liefbed) AND lfb.sa = 1 AND zlb.sa = 1;

Neither dbaccess 7.25 nor isql 7.32 support the ANSI '92 syntax for outer joins, you have to use the older syntax that Informix has always supported for outer joins. That means that the INNER, LEFT, RIGHT, and FULL keywords are not recognized and OUTER requires a comma separator and is only left outer join. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 28, 2009 at 6:42 AM, Ralf Hackmann <ralf.hackmann@gmail.com>wrote: > On 27 Okt., 22:30, Art Kagel <art.ka...@gmail.com> wrote: > > VERSION? > > > dbaccess -v > DB-Access Version 7.25.UC6R1> Software Serial Number AAA#B000000 > > isql -v > IBM INFORMIX-SQL Version 7.32.UC4 > Software Serial Number RDS#N000000 > > > But I checked my syntax and saw that I forgot a comma "," before > "OUTER" > Now it runs > > I thougt there is a comma-Join "," , a OUTER JOIN, INNER JOIN, RIGHT > JOIN, LEFT JOIN, > and if I use OUTER JOIN, INNER JOIN, RIGHT JOIN, LEFT JOIN, I dont > have to set "," > befor it. > I used this tutorial > http://www.sql-und-xml.de/sql-tutorial/tabellen-verknuepfen-mit-join.html > > Hier is the right query that shows alle 1052 record > > Thanks all > > UNLOAD TO lieferantenstamm.csv DELIMITER ";" > SELECT krd.knr, krd.nam, krd.tlf, krd.liefnr, zlb.bezeich1,> lfb.bezeich > FROM fyrkr1 krd, OUTER fyzlb zlb, OUTER fylfb lfb > WHERE (krd.zahlbed=zlb.zahlbed) > AND (krd.liefbed=lfb.liefbed) > AND lfb.sa = 1 > AND zlb.sa = 1; > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >