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. <http://www.plus2net.com/sql_tutorial/sql_linking_table.php> how is this different/better than a many-to-many, such as <http://www.plus2net.com/sql_tutorial/sql_inner_join.php>? Isn't that a better way of doing the same thing? Or, not? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
