/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 vote256 views3 answers
Find below average salary in sql
SQL
1 vote269 views1 answer
Postgresql not in
SQL
7 votes253 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
4 votes269 views4 answers
Pl sql output
SQL
-1 vote254 views1 answer
Search all database tables for a value sqlserver
SQL
14 votes275 views4 answers
Sql compiler
SQL
0 vote260 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote256 views1 answer
Postgresql alter column nullable
SQL
5 votes259 views1 answer
Purge undo tablespace usage
SQL
0 vote260 views1 answer
Report in database
SQL