在经典的asp/vbscript SQL字符串中连接
问题描述:
我想选择列和连接表,其中连接条件连接点以外的所选列。对于例如在经典的asp/vbscript SQL字符串中连接
SELECT TBL1.ID,
TBL1.COUNTRY As A,
TBL1.STATE As B,
TBL1.CODE As C
FROM TBL1, TBL2
WHERE TBL2.ID = A+'.'+B+'.'+C
的数据是,这样TBL2.ID
看起来像 'US.NY.61',其中美国是TBL1.COUNTRY
,纽约是TBL1.STATE
等
UPDATE:SQL小提琴:http://sqlfiddle.com/#!3/26b6b/4
答
如何尝试这样的事情
SELECT TBL1.ID,
TBL1.COUNTRY As A,
TBL1.STATE As B,
TBL1.CODE As C
FROM TBL1
INNER JOIN TBL2 ON CAST(TBL1.COUNTRY AS varchar(20)) + '.' + CAST(TBL1.STATE AS varchar(20)) + '.' + CAST(TBL1.CODE AS varchar(20)) = CAST(TBL2.ID AS varchar(20))
在组合和比较它们之前添加了将4个字段强制转换为varchar的代码。
答
SELECT T.name,T2.nam FROM
T INNER JOIN T2
ON T.id = (T2.one + '.' + CAST(T2.two as varchar(50)) + '.' + CAST(T2.thr as varchar(50)))
我似乎有数据类型的问题,请参阅sql小提琴 – greener 2012-04-25 21:05:47
请参阅下面的解决方案 – Jatin 2012-04-25 21:15:06