/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 vote257 views1 answer
Including parameters in OPENQUERY
SQL
0 vote284 views1 answer
Mariadb current date plus 1 day
SQL
0 vote304 views2 answers
Check if sql temp table exists
SQL
0 vote359 views1 answer
Mysql show schema
SQL
9 votes288 views6 answers
Check constraint in sql
SQL
0 vote266 views1 answer
Grouping by email domain mysql
SQL
3 votes284 views2 answers
Install mysql powershell
SQL
0 vote286 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
7 votes296 views1 answer
Oracle alter sequence restart start with
SQL
0 vote272 views1 answer
Selecting Data in SQL - Select Data
SQL