/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

1 vote173 views1 answer
Increase date by one day in sql oracle
SQL
0 vote123 views1 answer
Oracle sql replace string in clob
SQL
0 vote182 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote165 views1 answer
Raven ql select count
SQL
1 vote187 views1 answer
Tsql replace value in json
SQL
1 vote178 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
3 votes193 views2 answers
To_char sql
SQL
0 vote176 views1 answer
Sql server roles and users
SQL
0 vote180 views1 answer
Select count concat string sql server
SQL
0 vote176 views1 answer
Ceil upto 2 decimal place mysql
SQL