/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

5 votes226 views2 answers
Oracle list columns schema
SQL
0 vote234 views1 answer
Where date in datetime mysql
SQL
0 vote232 views1 answer
Datetime postgres typeorm
SQL
0 vote238 views2 answers
Sql server Insert Into table
SQL
0 vote233 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote233 views1 answer
Sql server express download
SQL
0 vote215 views1 answer
Pl/sql loop example
SQL
25 votes239 views6 answers
How to change column name in mysql
SQL
0 vote220 views1 answer
Mysql command prompt date insert format
SQL
0 vote235 views3 answers
Sql drop all tables
SQL