/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 vote134 views1 answer
Mysql row generator
SQL
0 vote122 views1 answer
Java sql insert return id
SQL
0 vote125 views1 answer
Oracle sql generate list of days
SQL
1 vote139 views1 answer
Oracle sequence last_number
SQL
0 vote125 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote121 views1 answer
Mysql select all table that have field names
SQL
-1 vote119 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote141 views1 answer
Oracle compile schema
SQL
2 votes125 views4 answers
Mysql select into new table
SQL
3 votes127 views3 answers
Your password does not satisfy the current policy requirements
SQL