/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 vote161 views1 answer
Order by monthly in sql
SQL
0 vote172 views1 answer
How to set all the min and sec data to zero in sql server
SQL
3 votes179 views2 answers
How to load files in mysql
SQL
1 vote175 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote209 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
1 vote157 views1 answer
Delete triger pl pg sql
SQL
0 vote160 views1 answer
Sql injection mitigation
SQL
0 vote185 views2 answers
Timing sql queries
SQL
2 votes176 views4 answers
Mysql get all tables row count
SQL
3 votes174 views1 answer
Null sql
SQL