/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

2 votes92 views2 answers
Get all columns from table sql
SQL
1 vote120 views1 answer
Postgres see sequence current state
SQL
3 votes102 views1 answer
Oracle rollback
SQL
1 vote97 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
10 votes108 views2 answers
Reset mysql root password mac
SQL
0 vote102 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote58 views1 answer
Deleted table in sql trigger
SQL
0 vote128 views1 answer
Hierarchal database table
SQL
0 vote94 views1 answer
Postgres set default schema
SQL
1 vote103 views2 answers
Oracle create synonym
SQL