/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 vote252 views1 answer
The package java.sql is not accessible
SQL
1 vote246 views1 answer
Sql dcl
SQL
1 vote252 views1 answer
Oracle truncate partition
SQL
0 vote258 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
2 votes231 views1 answer
Oracle sql day of month from date
SQL
0 vote227 views1 answer
Uncomment listen_address=localhost
SQL
5 votes259 views1 answer
Sql integer to serial
SQL
9 votes222 views2 answers
Oracle all tables in schema
SQL
1 vote259 views1 answer
Postgres see sequence current state
SQL
0 vote248 views1 answer
Postgresql list extensions
SQL