/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

0 vote141 views1 answer
Postgresql certain first 4 characters in string
SQL
-1 vote236 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
9 votes160 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote160 views3 answers
Database restoring error
SQL
0 vote148 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote163 views1 answer
Age postgres
SQL
0 vote154 views1 answer
Mysql export search results
SQL
12 votes239 views4 answers
How to drop all tables in postgresql
SQL
0 vote156 views1 answer
Print boolean in plsql
SQL
5 votes153 views3 answers
Sql max value in column
SQL