create view viewName
asselect a.*,b.type_name,c.by_name
from 表a a
left join 表b b on a.col_id = b.col_id
left join 表c c on a.col_id = c.col_id
asselect a.*,b.type_name,c.by_name
from 表a a
left join 表b b on a.col_id = b.col_id
left join 表c c on a.col_id = c.col_id
解决方案 »
- sqlserver2005或者2008怎么开启xp_cmdshell啊。常用的方法不行~
- win7 与sql 求助!!!thanks!!!
- 如何把某一字段的所有值做为一个字符串输出?
- 字段如果空要怎么模糊查询
- 初学SQL.请教大吓们两个问题?
- SQL语句 取与当前值不重复的一个非连续字段的最小空白值
- 求一个查询每天流水记录的SQL语句
- MSSql和MySql数据库的共用问题,希望高手给个思路!
- 一个打不开SQL Server 2000中的数据表的问题,急!在线等待......
- 子查询返回值多于一个的情况!! 用SQL搞定!感谢帮助!
- 怎么看备注字段(Text型)的内容(当LongText状态)
- 问最最基础的问题
asselect a.*,b.type_name,c.by_name
from 表a a
left join 表b b on a.col_id = b.col_id
left join 表c c on a.col_id = c.col_id
sql92语句如下:create view v1
as
select a.id,a.name,b.type_name,c.by_name from 表a as a,表b as b,表c as c
where a.col_id=b.col_id and a.col_id=c.col_id
as
select a.*,b.type_name,c.by_name
from 表a a
left join 表b b on a.col_id = b.col_id
left join 表c c on a.col_id = c.col_id
asselect a.*,b.type_name,c.by_name
from 表a a,表b b ,表c c where
a.col_id = b.col_id and a.col_id = c.col_id
create view 视图名
as
select *
,type_name=(select type_name 表b where col_id=a.col_id)
,by_name=(select by_name from 表c where col_id=a.col_id)
from 表a a
as
select a.*,b.type_name,c.by_name
from 表a a
left join 表b b on a.col_id = b.col_id
left join 表c c on a.col_id = c.col_id
as
select a.*,b.type_name,c.by_name
from 表a a join 表b b on a.col_id=b.col_id
join 表c on b.col_id=c.col_id
from #t
请问我想实现这样的功能这样好像不行啊
日期 摘要 名称 入库批次 充值有效期 入库数量 出库 库存
2003-08-01 入库 移动 001 10 10
2003-08-02 出库 711 3 7
2003-08-02 出库 百佳 7 0
2003-08-17 入库 移动 003 5 5
2003-08-22 出库 711 4 1
合计 — — — 15 14 1