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 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
Maybe i'm crazy and it's just late but i'm pretty sure what you have
there IS an inner join. Inner join is the default join type if you don't
explicitly specify the join type. If you do specify the join type you'd
have to use ON or USING.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
