SQL support ?

Kim Schulz <[email protected]> Mon, 21 Mar 2005 11:15:59 +0100

Newsgroups	gmane.comp.db.mckoi
Organization	Aalborg University
Message-ID	<[email protected]>

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. 


-- 
   Kim Schulz   | Fundanemt Content Management system:         
 Geek by nature | http://www.fundanemt.com                    
   schulz.dk    | http://www.fundausers.org                    


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