查找两个表之间同一列中具有不同值的所有行SQL

Question

我有2个表，我想找到当id和uid是相同的，有不同的fsvsFSFG。还有一个附加条件，Num必须为6。这是正确的问题吗?

table t1                table t2
id  fs  Num             uid FSFG    

我查询

SELECT *
FROM t1 INNER JOIN t2 ON id = uid
WHERE fs != FSFG AND Num = 6

Answer 1

是，这个查询是

SELECT *
FROM t1 INNER JOIN t2 ON id = uid
WHERE fs != FSFG AND Num = 6