INNER and OUTER JOIN syntax in 7.1
Posted in 1996
I am developing a visual SQL query builder component for Boland's
Delphi language. It currently supports Interbase, Sybase, the "other"
database, Borland's Local SQL.
I would like to add support for Informix but I am find the necessary
information a bit hard to find.
What I would like to know is;
1. Does Informix support table joins using JOIN keyword and if so does
it support INNER, OUTER joins etc., for example this is legal in
Interbase, is it also legal in Informix?
SELECT T1.EMP_NO, T1.NAME, Sum(T2.SALETOTAL) AS SALES
FROMEMPLOYEE T1 INNER JOIN ORDERS T2
ON T1.EMP_NO = T2.EMP_NO
GROUP BY T1.EMP_NO, T1.NAME
ORDER BY SALES DESC
2. Does Informix support quotes for table/column names for names that
may be reserved words or contain spaces?
3. Which sql standard does 7.1 support?
regards
Jeffrey Cooke
100026.3107@compuserve.com