Re: INNER and OUTER JOIN syntax in 7.1
> I would like to add support for Informix but I am find the necessary
> information a bit hard to find.
Have you tried the manuals? :-)
> 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
> FROM> EMPLOYEE T1 INNER JOIN ORDERS T2
> ON T1.EMP_NO = T2.EMP_NO
> GROUP BY T1.EMP_NO, T1.NAME
> ORDER BY SALES DESC
It would look like this in Informix:
SELECT T1.EMP_NO, T1.NAME, Sum(T2.SALETOTAL) SALES
FROM EMPLOYEE T1, ORDERS T2
WHERE 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?
Not that I know of.
> 3. Which sql standard does 7.1 support?
Er. Ah. <Blush> Don't know. SQL-92? Something like that...
--
Ciao,
Billy
+------------------------------------------------------------------------------+
| Billy Wheeler Junior Programmer / Director The West Solutions Group |
+------------------------------------------------------------------------------+
| (E) billy@west.co.za (U) http://www.west.co.za/billy.html |
+------------------------------------------------------------------------------+
| A WAY COMPUTERS CHANGED THE WORLD: 1 million banking errors |
+------------------------------------------------------------------------------+