/SQL/How to relationship query two different tables in MySQL

How to relationship query two different tables in MySQL

How to combine 2 tables in MySQL

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);

Source: tutorialspoint.com

How to relationship query two different tables in MySQL

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

Source: plus2net.com

Similar codes

8 votes316 views1 answer
Racle create auto increment column
SQL
4 votes286 views1 answer
Delete record mysql query
SQL
0 vote304 views1 answer
Suse status MySQL
SQL
0 vote305 views1 answer
Do you know sql
SQL
0 vote287 views1 answer
Acual month sql
SQL
0 vote290 views1 answer
Learn sqlite dart
SQL
1 vote307 views1 answer
How to delete data from sql database in android
SQL
4 votes305 views1 answer
Oracle error line
SQL
1 vote249 views1 answer
Restart identity postgresql
SQL
0 vote306 views1 answer
How to start my sql server on mac
SQL