/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 vote152 views2 answers
How covert into int in maria db
SQL
5 votes135 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote159 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote141 views1 answer
Psql initialization
SQL
37 votes159 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote151 views1 answer
Get cpu details sql
SQL
0 vote147 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote161 views1 answer
Print intervals of 15 minutes in sql query
SQL
10 votes154 views1 answer
All_dependencies
SQL
10 votes157 views1 answer
How to import database in mysql by cmd
SQL