ÇóSqlÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

±íA
cPapcNo cCstId iSuAmt
000001 01001 100
000002 01002 150
000003 01001 200
000004 01002 50
000005 01003 30
000006 01001 50

±íB
dPayNo cCstId iSuAmt
000001 01001 50
000002 01003 10
000003 01003 30
000004 01001 50
000005 01002 30
000006 01002 100

²éѯ½á¹û
cPapcNo cCstId iSuAmt dPayNo cCstId iSuAmt
000001 01001 100 000001 01001 50
000003 01001 200 000004 01001 50
000006 01001 50

---

µÈ´ý¸ßÊÖ¡£¡£¡£

---

½á¹ûÔõô³öÀ´µÄ°¡

---

ÒýÓÃ

µÈ´ý¸ßÊÖ¡£¡£¡£

SQL code:
WHERE cCstId='01001'

---

Ö»²î01001 µÄ°¡ 
2005ÓÃrow number

SQL code:

select * from
(Select Row_number() over(order by getdate()) id,cPapcNo,cCstId,iSuAmt
from A where A.CstID='01001')A
left join
(Select Row_number() over(order by getdate()) id,cPapcNo,cCstId,iSuAmt
from B where b.CstID='01001') B On A.id=B.id and a.cPayNo=B.cPayNo

---

2000Òª½èÖúÁÙʱ±í

---

Õâ¸ö²»¿ÉÒÔÓÃ×óÓÒÁ¬½ÓÀ´×ö£¬
ÓÐʱºò»á³öÏÖA±íµÄ¼Ç¼¶à¹ýB±íµÄ¼Ç¼£¬
ÓÐʱºò»á³öÏÖA±íµÄ¼Ç¼ÉÙ¹ýB±íµÄ¼Ç¼
{{----