/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 vote374 views2 answers
Disallowed function mysql to_date()
SQL
0 vote326 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote314 views1 answer
Sql view index
SQL
0 vote383 views1 answer
Query for backup a database at another location in file system
SQL
1 vote326 views1 answer
Oracle list data files
SQL
0 vote342 views1 answer
Sql check if column exists
SQL
0 vote312 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
-1 vote311 views2 answers
Full join sql
SQL
3 votes351 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote369 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL