/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 vote303 views1 answer
Get last date join sql
SQL
11 votes322 views1 answer
Oracle view source
SQL
0 vote311 views1 answer
Where field is null sql knex
SQL
0 vote311 views1 answer
Postgresql in vs any performance
SQL
8 votes336 views1 answer
See all users mysql
SQL
0 vote319 views1 answer
Oracle sql number to varchar2
SQL
0 vote310 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote309 views1 answer
Describe table in sql
SQL
5 votes286 views3 answers
Truncate function in sql oracle
SQL
0 vote322 views1 answer
Vs 2019 connect to local mysql database
SQL