求助:表中两个字段关联外表同一个字段,如何取值?
tab1:
id,sfid1,sfid2......
tab2:
sfid,bh......
在datawindow的sql语句中:
select tab1.id,
tab2_a.bh,
tab2_b.bh,
tab1.sfid1,
tab2.sfid2,
...
from tab1
left outer join tab2 tab2_a on tab1.sfid1 = tab2_a.sfid
left outer join tab2 tab2_b on tab1.sfid2 = tab2_b.sfid
问题:
我在取tab2_a.bh,tab2_b.bh时遇到错误(Invalid Datawindow row/column),所用语句如下:
long ll_row
string ls_bh1,ls_bh2
ll_row = dw_1.getrow()
ls_bh1 = dw_1.getitemstring(ll_row,"tab2_a_bh")
ls_bh2 = dw_1.getitemstring(ll_row,"tab2_b_bh")
请各位朋友帮忙看看。先谢谢各位!