SELECT dbo.ColumnsCatalogs.ParentID AS Expr2, dbo.ColumnsCatalogs.*, dbo.Module.*, dbo.Module.Url AS Expr1
FROM dbo.ColumnsCatalogs INNER JOIN dbo.Module
ON convert(varchar(255), dbo.ColumnsCatalogs.ParentID) = dbo.Module.Url
where UID=356最后显示UID不明确
FROM dbo.ColumnsCatalogs INNER JOIN dbo.Module
ON convert(varchar(255), dbo.ColumnsCatalogs.ParentID) = dbo.Module.Url
where UID=356最后显示UID不明确
表名字带上
dbo.ColumnsCatalogs.UID = dbo.Module.UID and dbo.ColumnsCatalogs.UID = 356
dbo.ColumnsCatalogs.UID = dbo.Module.UID and dbo.ColumnsCatalogs.UID = 356
这一句 是你两个表的UID相等数据才会被查出来
列名 'CatalogName' 不明确。
where ColumnsCatalogs.UID=356
不要写 dbo.ColumnsCatalogs.*
一个一个字段写
每个字段来自于哪张表就把表名字带上,相同名字就取别名(需要查出的话)
SELECT dbo.ColumnsCatalogs.ParentID AS Expr2, dbo.ColumnsCatalogs.*, dbo.Module.*, dbo.Module.Url AS Expr1
FROM dbo.ColumnsCatalogs INNER JOIN dbo.Module
ON dbo.ColumnsCatalogs.UID=dbo.Module.UID AND
convert(varchar(255), dbo.ColumnsCatalogs.ParentID) = dbo.Module.Url
where dbo.ColumnsCatalogs.UID=366
哈哈 你也是wower啊 哈哈 不错!加油加油!