t's true a JOIN, comma-style or not, does "link" data in one table to another
table, it is NOT a "SQL LINKING TABLE command" as implied in the tutorial. It is a
JOIN, and there is no such command as far as I know.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thufir wrote:
SELECT product_name, customer.name, date_of_sale
FROM `sales` , product, customer
WHERE product.product_id = sales.product_id
and customer.customer_id = sales.customer_id LIMIT 0, 30
The above SQL command links three tables and display the required
result. The tables are linked by
SELECT product_name, customer.name, date_of_sale
FROM `sales` , product, customer
WHERE product.product_id = sales.product_id
and customer.customer_id = sales.customer_id LIMIT 0, 30
The above SQL command links three tables and display the required
result. The tables are linked by their ID fields
