SQL查询结果横向显示
摘要：
第一张表S，车类型表第二张表C，姓名表第三张表SC，两个表的关系还有价格我把他们加在一个视图里面。视图代码SELECT dbo.s.id AS s_id, dbo.c.id AS c_id, dbo.c.name AS c_name, dbo.s.name AS s_name, dbo.sc.sMoneyFROM dbo.c INNER JOIN dbo.sc ON dbo.c.id = dbo.sc.c_id INNER JOIN dbo.s ON dbo.sc.s_id = dbo.s.id要显示的结果SQL的语句。declare @sql varchar(8000)set @sql = 阅读全文
posted @ 2011-02-23 19:38 邹泽栋 阅读(3643) 评论(0) 推荐(0) 编辑
