Re: SQL support ?

The only supported composite table function in Mckoi SQL at this time is 
UNION ALL.  The other composite functions are being worked on.

Toby.

Kim Schulz wrote:

> hi
> What is wrong with the following since SQL statements since McKoi wont
> accept them:
> 
> SELECT * FROM table1 NATURAL INNER JOIN table2 ON table1.id=table2.id
> (NATURAL not expected)
> SELECT * FROM table1 INTERSECT SELECT * FROM table2
> (INTERSECT not expected)
> SELECT * FROM table1 EXCEPT SELECT * FROM table2
> (EXCEPT not expected)
> 
> and 
> SELECT * FROM table1 UNION SELECT * FROM table2
> trows PENDING and nothing else. 
> 
> According to the O'reilly SQL pocket reference, all of these are in
> SQL92. 
> 
> 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]