创建视图错误！

[DiligencyMan]

alter view vcode_info_details
as 

select a.*,
	b.area_name, b,zone_name, b.street_name, b.resid_name,
	b.code, b.zone_code, b.street_code, b.resid_code 
from info_details a
inner join report_sys_area b
on a.area_id=b.id 

为什么报一下错误呢？
服务器: 消息 207，级别 16，状态 3，过程 vcode_info_details，行 4
列名 'b' 无效。

[DiligencyMan]

等待！

[oraclelogan]

alter view vcode_info_details
as

select a.*,
b.area_name, b,zone_name, b.street_name, b.resid_name,
b.code, b.zone_code, b.street_code, b.resid_code
from info_details a
inner join report_sys_area b
on a.area_id=b.id

把,改成.吧，楼主明白了吗？

[oraclelogan]

把,改成.

[Zoezs]

不知道，帮顶

[changjiangzhibin]

alter view vcode_info_details
as 

select a.*,
    --b.area_name, b,zone_name, b.street_name, b.resid_name,
    b.area_name, b.zone_name, b.street_name, b.resid_name,  --应为.不是，
    b.code, b.zone_code, b.street_code, b.resid_code 
from info_details a
inner join report_sys_area b
on a.area_id=b.id 

[让你望见影子的墙]

alter view vcode_info_details
as

select a.*,
b.area_name, b.zone_name, b.street_name, b.resid_name,
b.code, b.zone_code, b.street_code, b.resid_code
from info_details a
inner join report_sys_area b
on a.area_id=b.id

[areswang]

alter view vcode_info_details
as

select a.*,
b.area_name, b,zone_name, b.street_name, b.resid_name,
b.code, b.zone_code, b.street_code, b.resid_code
from info_details a
inner join report_sys_area b
on a.area_id=b.id

[htl258_Tony]

只需逗号改为点，上面回答的都对。

[areswang]

[Quote=引用 6 楼 HEROWANG 的回复:]
alter view vcode_info_details
as

select a.*,
b.area_name, b.zone_name, b.street_name, b.resid_name,
b.code, b.zone_code, b.street_code, b.resid_code
from info_details a
inner join report_sys_area b
on a.area_id=b.id
[/Quote]
靠,感觉很有缘分!