CREATE VIEW dbo.BUILDING_RESLIST
AS
SELECT BUILDING_RES.bBuildingType, BUILDING_RES.bResID, BUILDING_RES.wAmount,
RESOURCE.wVisualID, RESOURCE.szName
FROM BUILDING_RES INNER JOIN
RESOURCE ON BUILDING_RES.bResID = RESOURCE.bResID
自己回自己