/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

1 vote189 views1 answer
Oracle grant on all tables in schema
SQL
0 vote191 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote186 views1 answer
Get clob size oracle
SQL
1 vote197 views1 answer
Import sql file mysql commadn line
SQL
0 vote218 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote185 views1 answer
Mysql date time string format python
SQL
3 votes209 views1 answer
Define REGEXP?
SQL
0 vote191 views1 answer
Oracle search in date columns
SQL
1 vote223 views1 answer
Find difference in dates sql
SQL
0 vote294 views1 answer
Placements hackerrank solution
SQL