bigddaddy(隐者 的是对的select a.id,a.name,a.tel from db a,db b *这里说,把这张表复制成为两张, 然后做查询* where a.name=b.name and a.tel=b.tel;关键就是那个重命名的复制.
select a.id,a.name,a.tel from db a,db b where a.name = b.name and a.tel = b.tel and a.rowid !=b.rowid
zgj8128123(zgj8128) 说的很对, 他的SQL很管用, 但是在2个表里面怎么选择呢就是这样table1:ID NAME TEL ------------------------------- 1 aa 123 2 bb 124 3 cc 332 4 aa 123table2: TABLE2ID ID NAME TEL ------------------------------- 1 1 aa 123 2 2 bb 124 3 3 dc 332 4 4 aa 123现在想要选择出来table2和table1中 table1.NAME=table2.NAME and table1.TEL = table2.TEL就是上边问题分成了2个表了, 请问怎么样来写SQL,谢谢
select table2.* from table2,table1,where table2.name=table1.name and table2.tel=table1.tel
问题解决了第一个问题: OPEN curSCPL02020 FOR select * from csv_up_wk where DAIGAKU_CODE = pDaigakuCd AND ZYUSIN_NO = pZYUSIN_NO AND NAMAE_KANJI || KEITAI_BANGO in ( Select NAMAE_KANJI || KEITAI_BANGO From csv_up_wk Where DAIGAKU_CODE = pDaigakuCd AND ZYUSIN_NO = pZYUSIN_NO group by NAMAE_KANJI || KEITAI_BANGO having count( NAMAE_KANJI || KEITAI_BANGO ) > 1 );第二个问题: OPEN curSCPL02020 FOR select * from csv_up_wk a ,cust_mst b where a.NAMAE_KANJI || a.KEITAI_BANGO in ( Select NAMAE_KANJI || KEITAI_BANGO From cust_mst Where DAIGAKU_CODE = pDaigakuCd group by NAMAE_KANJI || KEITAI_BANGO ) AND a.DAIGAKU_CODE = pDaigakuCd AND a.ZYUSIN_NO = pZYUSIN_NO AND a.DAIGAKU_CODE = b.DAIGAKU_CODE AND a.NAMAE_KANJI || a.KEITAI_BANGO = b.NAMAE_KANJI || b.KEITAI_BANGO;
Select ID,Name,Tel from table1
Where Name+Tel In(
Select Name+Tel From table1
group by Name+Tel
having count(Name+Tel)>1)
from table a,table b
where a.name=b.name and a.tel=b.tel;
http://community.csdn.net/Expert/topic/3140/3140416.xml?temp=.6964075
的是对的select a.id,a.name,a.tel
from db a,db b *这里说,把这张表复制成为两张, 然后做查询*
where a.name=b.name and a.tel=b.tel;关键就是那个重命名的复制.
from db a,db b
where a.name = b.name and a.tel = b.tel and a.rowid !=b.rowid
但是在2个表里面怎么选择呢就是这样table1:ID NAME TEL
-------------------------------
1 aa 123
2 bb 124
3 cc 332
4 aa 123table2:
TABLE2ID ID NAME TEL
-------------------------------
1 1 aa 123
2 2 bb 124
3 3 dc 332
4 4 aa 123现在想要选择出来table2和table1中
table1.NAME=table2.NAME and table1.TEL = table2.TEL就是上边问题分成了2个表了, 请问怎么样来写SQL,谢谢
不是很清楚么?
------------------------------------------------------------------------------
三张表,TA
------------------------------------------
TA_ID TA_NAME
------------------------------------------
0001 TA1
0002 TA2
0003 TA3
------------------------------------------TB
------------------------------------------
TB_ID TB_NAME
------------------------------------------
001 TB1
002 TB2
------------------------------------------TATB
------------------------------------------
TA_ID TB_ID
------------------------------------------
0001 001
0001 002
0002 001--------------------------------------------------------------------
--------------------------------------------------------------------
用三张表做关连,希望得出
--------------------------------------------
TA_ID TA_NAME TB_NAME_STR
--------------------------------------------
0001 TA1 TB1,TB2
0002 TA2 TB2
0003 TA3
-------------------------------------------------
OPEN curSCPL02020 FOR
select
*
from
csv_up_wk
where
DAIGAKU_CODE = pDaigakuCd
AND
ZYUSIN_NO = pZYUSIN_NO
AND
NAMAE_KANJI || KEITAI_BANGO
in
(
Select
NAMAE_KANJI || KEITAI_BANGO
From
csv_up_wk
Where
DAIGAKU_CODE = pDaigakuCd
AND
ZYUSIN_NO = pZYUSIN_NO
group by
NAMAE_KANJI || KEITAI_BANGO
having count(
NAMAE_KANJI || KEITAI_BANGO
) > 1
);第二个问题:
OPEN curSCPL02020 FOR
select
*
from
csv_up_wk a ,cust_mst b
where
a.NAMAE_KANJI || a.KEITAI_BANGO
in
(
Select
NAMAE_KANJI || KEITAI_BANGO
From
cust_mst
Where
DAIGAKU_CODE = pDaigakuCd
group by
NAMAE_KANJI || KEITAI_BANGO
)
AND
a.DAIGAKU_CODE = pDaigakuCd
AND
a.ZYUSIN_NO = pZYUSIN_NO
AND
a.DAIGAKU_CODE = b.DAIGAKU_CODE
AND
a.NAMAE_KANJI || a.KEITAI_BANGO =
b.NAMAE_KANJI || b.KEITAI_BANGO;