关于2张表的查询问题~~
lg1kg 2003-08-22 02:34:22 我用union命令将两张结构一样的表联在一起
现在我需要连在一起的sql集合进行查询,应该怎么做呢?
sql="SELECT NBLT.Department AS Department, NBLT.Title AS title, NBLT.Content AS content,"
sql=sql&" Option_Depart.Name AS departname, NBLT.Sender AS sender, NBLT.Datetime AS datetime"
sql=sql&" FROM NBLT INNER JOIN Option_Depart ON NBLT.Department = Option_Depart.Id"
sql=sql&" UNION SELECT NBLT_f.Department AS Department, NBLT_f.Title AS title,"
sql=sql&" NBLT_f.Content AS content, Option_Depart.Name AS departname, NBLT_f.Sender AS sender, NBLT_f.Datetime AS datetime"
sql=sql&" FROM NBLT_f INNER JOIN Option_Depart ON NBLT_f.Department = Option_Depart.Id"
if Request("title")<>"" then
sql=sql&" and nblt.title like '%"&Request("title")&"%' "
end if '这条命令报错
[Microsoft][ODBC SQL Server Driver][SQL Server]列前缀 'NBLT' 与查询中所用的表名或别名不匹配。