Wat是oraclesql中join和minus之间的确切区别-Watisexactdifferencebetweenjoinandminusinoraclesql

0  

a JOIN finds rows that are matched between the two tables.

JOIN查找两个表之间匹配的行。

A MINUS finds rows that exist in the first table but do not exist in the second table.

MINUS查找第一个表中存在但第二个表中不存在的行。

Hemant K Chitale

Hemant K Chitale

0  

A join simply does an intersection between the tables.

连接只是在表之间进行交集。

A minus do a subtraction between tables finding rows that does exists in table 1 but not in table 2.

减去表格之间的减法,查找表1中存在的行但不存在于表2中。

Thanks to @a_horse_with_no_name

感谢@a_horse_with_no_name