Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Kent, UK
    Posts
    2

    Question Unanswered: Double links to same table

    Guys,

    I have two procedures, One works the second doesnt but i dont understand why, anybody got any ideas?

    This one works
    SELECT Results.EventID, Results.ClassID, Results.RidingNumber, Results.CrewID, Results.MotoID, Results.Finished, Results.Round, Crew.Rider, Rider.firstname AS RiderFname, Rider.LastName AS RiderLname
    FROM (Results LEFT JOIN Crew ON Results.CrewID=Crew.CrewID) LEFT JOIN Partaker AS Rider ON Crew.rider=Rider.PartakerID
    WHERE (Results.ClassID=1)
    ORDER BY Results.Round, Results.MotoID, Results.Finished;


    This one doesnt:-
    SELECT Results.EventID, Results.ClassID, Results.RidingNumber, Results.CrewID, Results.MotoID, Results.Finished, Results.Round, Crew.Rider, Rider.firstname AS RiderFname, Rider.LastName AS RiderLname
    FROM ((Results LEFT JOIN Crew ON Results.CrewID=Crew.CrewID) LEFT JOIN Partaker AS Rider ON Crew.rider=Rider.PartakerID) LEFT JOIN Partaker AS Passenger ON Crew.passenger=Passenger.PartakerID
    WHERE (Results.ClassID=1)
    ORDER BY Results.Round, Results.MotoID, Results.Finished;

    i get this error:-
    "The table 'Partaker' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

    Relationship table attached

    G
    Attached Files Attached Files
    Last edited by connollyg; 12-17-03 at 06:17.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I tried both as queries and they ran fine... though I have no data.

    What are you doing with these queries in your code?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •