2个表,一个表a的内容是
id num content
1 001 haha
2 002 ttttdfas
3 003 fdasft4r2表b的内容是
id num age tel email
1 001 23 43242 [email protected]
2 002 32 2343242 [email protected]
3 003 32 42423432 [email protected]
4 004 18 34242342 [email protected]
5 005 12 4242342 [email protected]
6 006 12 42342342 [email protected]
我现在要得内容是表b中汗有表b的内容所有内容c表
id num content age tel email
1 001 haha 23 43242 [email protected]
2 002 ttttdfas 32 2343242 [email protected]
3 003 fdasft4r2 32 42423432 [email protected]记得很简单,但是我忘了SELECT *
FROM a
WHERE (Col001 IN
(SELECT ktbh
FROM b))还少什么?我记不起来了,求教了
id num content
1 001 haha
2 002 ttttdfas
3 003 fdasft4r2表b的内容是
id num age tel email
1 001 23 43242 [email protected]
2 002 32 2343242 [email protected]
3 003 32 42423432 [email protected]
4 004 18 34242342 [email protected]
5 005 12 4242342 [email protected]
6 006 12 42342342 [email protected]
我现在要得内容是表b中汗有表b的内容所有内容c表
id num content age tel email
1 001 haha 23 43242 [email protected]
2 002 ttttdfas 32 2343242 [email protected]
3 003 fdasft4r2 32 42423432 [email protected]记得很简单,但是我忘了SELECT *
FROM a
WHERE (Col001 IN
(SELECT ktbh
FROM b))还少什么?我记不起来了,求教了
FROM b
INNER JOIN a
ON a.num=b.num AND a.id=b.id
SELECT b.id,b.num,a.content,b.age,b.tel,b.email
FROM b b, a a
where
a.num*=b.num AND a.id*=b.id