question

Hi there. Basically, I have a JobOrder Table with the ff definition:

ID nvarchar(50) [the Job Order Number] pk, SiteID int fk, ClientID int fk, VehicleID int fk, OrderDate datetime, InsuranceID int fk, SalesAssistant int fk, Note text

with SiteID, ClientID, VehicleID, InsuranceID and SalesAssistantID as foreign keys. Getting to view the data from the JobOrder table in a GridView is fine, no problems or errors. But when I try to edit the record, using the ff code in a storedprocedure, I get the error: "The correlation name 'JobOrderSite' is specified multiple times in a FROM clause"

  SELECT
      dbo.JobOrder.ID ,
      dbo.JobOrder.ClientID ,
      dbo.Client_Site.ClientName ,
      dbo.JobOrder.SiteID ,
      dbo.Site.SiteName ,
      dbo.JobOrder.VehicleID ,
      dbo.Vehicle_Name.CarName ,
      dbo.JobOrder.OrderDate ,
      dbo.JobOrder.InsuranceID ,
      dbo.Insurance.InsuranceName ,
      dbo.JobOrder.SalesAssistant ,
      dbo.SalesAssistant.AssistantName ,
      dbo.JobOrder.Note ,
      dbo.Vehicle.ClientSitePlateNo
  FROM
      dbo.JobOrder
  INNER JOIN dbo.Client_Site ON dbo.JobOrder.ClientID = dbo.Client_Site.ID
  INNER JOIN dbo.Site ON dbo.JobOrder.SiteID = dbo.Site.ID
  INNER JOIN dbo.Vehicle ON dbo.JobOrder.VehicleID = dbo.Vehicle.ID
  INNER JOIN dbo.Vehicle_Name ON dbo.Vehicle.CarName = dbo.Vehicle_Name.ID
  INNER JOIN dbo.SalesAssistant ON dbo.JobOrder.SalesAssistant = dbo.SalesAssistant.ID
  INNER JOIN dbo.Insurance ON dbo.JobOrder.InsuranceID = dbo.Insurance.ID
  WHERE
      ( dbo.JobOrder.ID = @ID )

I know that this normally happens when an alias is used more than once for different tables, which is why I removed all the aliases I used and just used the field names. But I still get this error. I'm really at my wits end. I have no idea what's wrong. When I execute the storedprocedure in sql server 2005, it works fine.

Thank you so much in advance for the help.