/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 vote110 views1 answer
Set column width in sqlplus
SQL
6 votes122 views2 answers
Mysql interval 1 day
SQL
1 vote111 views1 answer
Sql headers delphi
SQL
0 vote75 views2 answers
Jupyter notebook connect to database
SQL
1 vote113 views1 answer
Add constraint sql
SQL
3 votes131 views1 answer
Where id is in list sql
SQL
2 votes129 views1 answer
How to show the whole table in sql
SQL
-1 vote66 views3 answers
Ubuntu install mssql
SQL
2 votes123 views2 answers
Create empty table from existing table
SQL
0 vote137 views1 answer
Trigger stock phpmyadmin
SQL