First I would advice you to take a closer look at:
http://dev.mysql.com/doc/refman/5.0/en/join.html
It will answer your question.
/Johan
??? wrote:
Hi
There is a schema example below: (From "A first course in database system")
Product (maker, model,type)
Pc (model, speed, ram, hd, rd, price)
Laptop (model, speed, ram, hd, screen, price)
Printer (model, color, type, price)
The statement below seems wrong based on MySQL 5.0, though it is from the
Solutions:
(SELECT maker, model, type AS productType FROM Product)
RIGHT NATURAL OUTER JOIN
((PC FULL NATURAL OUTER JOIN Laptop) FULL NATURAL OUTER JOIN Printer);
Dose MySql support this statement? And how I can solve it?
BJUT
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
