还是数据库的问题

[hannah80]

Public Function GetCarInfo(ByVal ID As String) As String
Dim sql As String
sql = "select * from 车辆 where kh_ID=" & ID
Dim rs As SqlDataReader
rs = SqlHelper.ExecuteReader(ConfigurationSettings.AppSettings("DSN"), CommandType.Text, sql)
If rs.Read Then
mintID = rs("kh_id")
mintCarID = rs("车牌号码")
mstrCarModel = rs("cx_id")
enf if
从表“车辆”里读取出来的“cx_id”是整数型的数据。我要从另一个表“车型”里读取出来的“cx_id”是字符型数据。他们分别有字段“cx_id”，我该怎样写代码？怎样通过共有的字段“cx_id”从“车型”表里读取字符型的数据。

[lifeforu]

select a.*,b.* from 车辆 a,车型 b where a.cx_id=cast(b.cx_id as int) and kh_id=...

[txlicenhe]

Select * from 车型 a join 车辆 b on a.cx_id = convert(varchar,b.cx_id)