Question

I have two tables one is Registration which has column as reg_id and first_name and other details and the other table is activity which also has reg_id ,first_name and other details with reg_id as common the tables. There can be multiple entries for 1 reg_id in activity table

我想以这样的方式询问这两个表格,我想知道所有那些在两个表格中都有不同名头的人。

Eg:if

1st table data
--------------                     
Reg_id   first_name                               
1        ashu
2        &parker
3        *fzz 
4        john


2nd Table data
--------------
Reg_id   first_name
1        ashu
2        parker
3        michel  
4        john

我的询问结果应归还2 3名女佣。

Answer 1

select table1.reg_id from table1
inner join table2 on table1.reg_id = table2.reg_id
where table1.first_name <> table2.first_name

select the one reg id, joing the tables on the reg id value. where the two first name fields don t equal each other

无论是哪种情况都不敏感。

Answer 2

和......

SELECT t1.reg_id 
FROM table1 t1
INNER JOIN table2 t2 ON t1.reg_id = t2.reg_id
WHERE t1.first_name <> t2.first_name

http://www.w3schools.com/sql/sql_join.asp“rel=“nofollow”http://www.w3schools.com/sql/sql_join.asp。

友情链接