34,590
社区成员
发帖
与我相关
我的任务
分享
DECLATE @ID
SELECT @ID=0
SELECT @ID=@ID+1 AS ID, DVD.ID AS DVDID,TYPE.ID AS TYPEID
INTO DVD_TYPE
FROM DVD INNER JOIN
GLB ON
DVD.NAME=GLB.NAME INNER JOIN
TYPE ON TYPE.NAME=GLB.TYPE
DECLATE @ID
SELECT @ID=0
SELECT @ID=@ID+1 AS ID, DVD.ID AS DVDID,ACTOR.ID AS ACTORID
INTO DVD_ACTOR
FROM DVD INNER JOIN
GLB ON
DVD.NAME=GLB.NAME INNER JOIN
ACTOR ON ACTOR.NAME=GLB.ACTOR
用这个试下
select D.ID,D.name,D.price,T.name as Type,A.name as Actor,D.picurl,D.addtime
from DVD D
join dvd_type TY
on D.ID=TY.DVDID
join Type T
on TY.TYPEID=T.ID
join DVD_ACTOR DV
on D.ID=DV.DVDID
join Actor A
on DV.ACTORID=A.ID
CREATE TABLE [dbo].[dvd_type](
[id] [int] IDENTITY(1,1) NOT NULL,
[dvdid] [int] NOT NULL,
[typeid] [int] NOT NULL
) ON [PRIMARY]