主题：[求助]SQL取另外一个表相同字段的内容

Dim cmd As New SQLCommand
Dim dt As DataTable
Dim cmb As WinForm.ComboBox
cmd.C
cmd.CommandText = "

SELECT DISTINCT mingcheng From {jixn} Where chanpinid = 另外一个表相同字段的内容"
dt = cmd.ExecuteReader()
cmb = e.Form.Controls("ComboBox4")
cmb.ComboList = dt.GetComboListString("mingcheng")

 

高手这个怎么完善一下，谢谢

 

取另外一张表和当前表某个字段相同的数据，谢谢

 

全部是用SQL从后台查找的，不是加载进来的表

Dim jx As String = e.Form.Controls("ComboBox4").value
Dim cmd As New SQLCommand
Dim dt As DataTable
Dim cmb As WinForm.ComboBox
cmd.C
cmd.CommandText = "SELECT DISTINCT mingcheng From {jixn} chanpinid = '" & jx & "'"

 

这里不能这样用吗？

提示错误
此主题相关图片如下：qq图片20140312165300.jpg