Re: select in 3 Tables

On Wed, Oct 28, 2009 at 07:36, Art Kagel <art.kagel@gmail.com> wrote: > Neither dbaccess 7.25 nor isql 7.32 support the ANSI '92 syntax for outer > joins, It is not something that DB-Access or ISQL has to recognize; it is all down to whether the underlying server recognizes the Standard SQL (it is an ISO standard more than an ANSI standard) notation. The programs cited just know how to find a semi-colon that isn't inside a comment or string and send the material that precedes it to the database for interpretation. In the case of ISQL, it is pretty much literally that simple - so it doesn't (yet) handle CREATE PROCEDURE statements very well. In the case of DB-Access, it does know how to handle the syntax of a CREATE PROCEDURE statement. But none of that matters for a single SELECT statement using OUTER notations. That said, DB-Access 7.25 comes with SE 7.25, and SE does not understand Standard SQL outer joins, so the old-style Informix OUTER join notation is all that you can use. ISQL 7.32 can connect to SE 7.2x - but since the server does not recognize Standard SQL outer joins, it is no help. ISQL 7.32 can also connect to IDS 7.3x and later - and the supported products (10.00 and later) do handle Standard SQL outer join notations. > 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. > > > > > > 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; > > -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Jonathan Swift<http://www.brainyquote.com/quotes/authors/j/jonathan_swift.html>; - "May you live every day of your life." -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>; - "I'm willing to admit that I may not always be right, but I am never wrong."