create view

[小曦子]

create table hyzl_user(
	uID int unsigned auto_increment,
	uName nvarchar(50) not null,
	uPass nvarchar(20) not null,
	utName nvarchar(50) not null,
	uSex char(5) not null,
	uBir datetime,
	uConNum nvarchar(20),
	uNum nvarchar(20),
	uQQ bigint(8),
	uImg nvarchar(200),
	uEmail nvarchar(50),
	uAddr nvarchar(100),
	uConAddr nvarchar(100),
	uUrl nvarchar(50),
	uUserTypeID int unsigned default 1,
	primary key(uID)
) ;


/*版块信息表*/
create table bk_Module(
	bk_Name nvarchar(50) not null,
	bk_userName nvarchar(50) not null,
	bk_ID int unsigned auto_increment,
	primary key(bk_ID)
);

create view bk_user as select 
	bk_Module.*,
	hyzl_user.*
	from bk_Module left join bk_Module on(bk_Module.bk_userName=hyzl_user.uName);

为什么插入最后一句view 语句的时候会报错呀:ERROR 1066 (42000): Not unique table/alias: 'bk_Module'

请各位前辈指教一下呀

[Lcindep110]

create table hyzl_user(
    uID int unsigned auto_increment,
    uName nvarchar(50) not null,
    uPass nvarchar(20) not null,
    utName nvarchar(50) not null,
    uSex char(5) not null,
    uBir datetime,
    uConNum nvarchar(20),
    uNum nvarchar(20),
    uQQ bigint(8),
    uImg nvarchar(200),
    uEmail nvarchar(50),
    uAddr nvarchar(100),
    uConAddr nvarchar(100),
    uUrl nvarchar(50),
    uUserTypeID int unsigned default 1,
    primary key(uID)
) ;

GO

/*版块信息表*/
create table bk_Module(
    bk_Name nvarchar(50) not null,
    bk_userName nvarchar(50) not null,
    bk_ID int unsigned auto_increment,
    primary key(bk_ID)
);

GO

create view bk_user as select 
    bk_Module.*,
    hyzl_user.*
    from bk_Module left join bk_Module on(bk_Module.bk_userName=hyzl_user.uName);

[小曦子]

我晕....我又一次看走眼了........啊.....................

[criedshy]

create view bk_user as select 
    bk_Module.*,
    hyzl_user.*
    from bk_Module left join hyzl_useron(bk_Module.bk_userName=hyzl_user.uName);

你两个表名字都是bk_Module 当然会错

[zetee]

create view bk_user as select
bk_Module.*,
hyzl_user.*
from hyzl_user left join bk_Module on(bk_Module.bk_userName=hyzl_user.uName);

[hhwyss]

from bk_Module left join bk_Module on
(bk_Module.bk_userName=hyzl_user.uName);

hyzl_user?