/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

4 votes171 views1 answer
Id primary key auto generated
SQL
0 vote208 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote190 views1 answer
Copy data from one postgres container to another
SQL
0 vote232 views1 answer
Sql query to find percentage of null values in a table
SQL
7 votes180 views2 answers
Mysql get year from date
SQL
4 votes179 views4 answers
Sqlite describe table
SQL
1 vote238 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
1 vote172 views1 answer
Mysql get character set
SQL
0 vote175 views1 answer
How to check xampp mysql password
SQL
0 vote191 views1 answer
Sql query to get contact form 7 fields
SQL