/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 vote136 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes158 views2 answers
Mysql find max value row
SQL
4 votes158 views4 answers
Check constraint in ms sql
SQL
0 vote160 views1 answer
Querry mysql by 2 columns
SQL
1 vote153 views1 answer
Oracle duration between timestamps
SQL
0 vote148 views1 answer
Import all databases mysql
SQL
0 vote150 views1 answer
Netstat -tln mysql
SQL
2 votes162 views2 answers
Postgresql get table names
SQL
0 vote186 views1 answer
Mysql equivalent decode oracle
SQL
0 vote168 views1 answer
How to get button for every record from mysql
SQL