/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 vote200 views1 answer
Mysql exception output
SQL
2 votes282 views1 answer
Brew start postgres manual
SQL
1 vote192 views3 answers
Mysql disable foreign keys check
SQL
0 vote201 views1 answer
Sql server list table sizes
SQL
0 vote214 views1 answer
Drop index in sql
SQL
1 vote188 views4 answers
Psql check tables command
SQL
5 votes201 views1 answer
Sort order on two columns sql
SQL
0 vote253 views1 answer
Drop view sql
SQL
0 vote220 views2 answers
How to get max from each department in sql
SQL
0 vote201 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL