- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28

|
dbo_aa.names
names ¦n¹³è¦n¬OÃöÁä¦r, ²³æªº¸Ü´«¤@¤UÄæ¦W
¥t¥~LEFT JOIN, ISNULL ªº¦bACCESS·|¦³¤£¦P¼gªk:
(¥H¤U§Ú§âDBO_AA.NAMES§ï¦¨DBO_AA.NAME)
SQL = "Select dbo_pro.*, dbo_aa.name as anames, iif(isnull(dbo_prok.name), '',dbo_prok.name)as namek "
SQL = SQL & "From (dbo_pro left outer join dbo_aa on dbo_pro.a01=dbo_aa.a01) "
SQL = SQL & "left join dbo_prok on dbo_pro.kano=dbo_prok.kano "
SQL = SQL & "Where dbo_pro.prno ='" & Sheet1.Range("K9") & "'"
SQL = SQL & " Order by dbo_pro.prno" |
|