Hi,
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 linke
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