/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

6 votes148 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes166 views2 answers
How to modify rows in SQL Server
SQL
0 vote144 views2 answers
How to count codition
SQL
0 vote156 views1 answer
Running percentage of total postgres
SQL
11 votes172 views2 answers
Import sql file laravel cmd
SQL
0 vote147 views1 answer
New rails app with mysql
SQL
0 vote139 views1 answer
Get clob size oracle
SQL
1 vote221 views3 answers
Showing all columns in an sqlite table
SQL
1 vote155 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
2 votes148 views1 answer
How to make multiple keys as primary in bdms
SQL