Error Running Import Script

Hi,
I am having problems running my import query. It runs to a point, then the next block of SQL it fails on, does anyone know why this is? I have included the code and the error message underneath. The import is ran using SQLwebadmin

Thanks
 

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [HOME_RECORDS]

AS

SELECT dbo.TEAMS.TEAM_ID, ISNULL(dbo.HW.COUNT_HOME_WINS, 0) AS W, ISNULL(dbo.HD.COUNT_HOME_DRAWS, 0) AS D,

ISNULL(dbo.HL.COUNT_HOME_LOSES, 0) AS L, ISNULL(dbo.HW.HGF, 0) +
ISNULL(dbo.HD.HGF, 0) + ISNULL(dbo.HL.HGF, 0) AS F,

ISNULL(dbo.HW.HGA, 0) + ISNULL(dbo.HD.HGA, 0) + ISNULL(dbo.HL.HGA, 0) AS A

FROM dbo.TEAMS LEFT OUTER JOIN

dbo.HW ON dbo.TEAMS.TEAM_ID = dbo.HW.F_HOME_TEAM LEFT OUTER JOIN

dbo.HD ON dbo.TEAMS.TEAM_ID = dbo.HD.F_HOME_TEAM LEFT OUTER JOIN

dbo.HL ON dbo.TEAMS.TEAM_ID = dbo.HL.F_HOME_TEAM







The following error occured while executing the query:

Server: Msg 208, Level 16, State 1, Line 3

Invalid object name 'dbo.HW'.