/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

-2 votes214 views1 answer
Create trigger syntax
SQL
0 vote208 views1 answer
Sql describe
SQL
0 vote205 views1 answer
Soql update query
SQL
0 vote205 views1 answer
Mysql select where text contains
SQL
34 votes257 views6 answers
Alter table add foreign key mysql
SQL
0 vote229 views2 answers
Advantages of stored procedures sql
SQL
16 votes216 views1 answer
Mssql int max value
SQL
0 vote227 views1 answer
What is between keyword used for
SQL
2 votes218 views1 answer
Get first 2 letter in sql
SQL
0 vote220 views1 answer
Postgresql show owner of database
SQL