/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 vote171 views1 answer
Mysql error codeigniter
SQL
3 votes140 views1 answer
Pl sql escape &
SQL
0 vote162 views1 answer
Mysql date without time
SQL
0 vote140 views1 answer
Set mysql socket file docker windows
SQL
1 vote129 views1 answer
Sql not equal multiple columns
SQL
0 vote135 views1 answer
Snap craft
SQL
1 vote162 views1 answer
Oracle apex version view
SQL
12 votes121 views5 answers
Sql merge
SQL
17 votes139 views3 answers
Cast in sql server
SQL
0 vote140 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL