vb access insert into书写格式

来源:百度知道 编辑:UC知道 时间:2024/05/30 14:39:38
lSql = ""
lSql = lSql & "SELECT"
lSql = lSql & " Z_手书出荷.出荷NO"
lSql = lSql & " , Z_手书出荷.出荷日"
lSql = lSql & " , Z_手书出荷.得意先CD"
lSql = lSql & " , M_得意先.略称"
lSql = lSql & " , Z_手书出荷.数量"
lSql = lSql & " , Z_手书出荷.総重量"
lSql = lSql & " , Z_手书出荷.备考"
lSql = lSql & " , Z_手书出荷.印刷FLG"
lSql = lSql & " , Z_手书出荷.材质FLG"
lSql = lSql & " , Z_手书出荷.预り区分"
lSql = lSql & " , Z_手书出荷.更新日"
lSql = lSql & " , M_ユーザー.ユーザー名"
lSql = lSql & " FROM"
lSql = lSql & " ("
lSql = lSql & " Z_手书出荷"
lSql = lSql & " LEFT JOIN"
lSql = lSql & " M_得意先"
lSql = lSql & " ON"
lSql = lSql &

-_- 为什么不用 “&=” 而用 "lSql = lSql &"。。。 看得头晕。不知道你在干什么。。。。寒

你给的是个普通的多表查询而已,没有什么插入语句啊~你想要什么东西啊

看的难受,另外VB6没有&=
要插到哪里?