Help with error message: Syntax error in FROM clause

[ye5man]

Hi guys, I hope you can help me with this annoying error :)

I'm using Access 2000, DSN-less connection.

My table names have no spaces nor are they keywords

I'm getting the error message:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Here's my SQL: (just an inner join)

SQLLarge = " SELECT MemberID, MemberTitle, MemberFirstName, MemberSurname, "

SQLLarge = SLQLarge & " MemberDateCommenced, MemberDateExpiry, MemberAddress1, MemberAddress2, "

SQLLarge = SLQLarge & " MemberAddress2, MemberAddress3, MemberPostcode, MemberTelephone, "

SQLLarge = SLQLarge & " MembershipTitle, MemberValidCard, MemberNotes, BranchTitle, StaffFirstname, StaffSurName "

SQLLarge = SLQLarge & " FROM BranchDetails"

SQLLarge = SLQLarge & " INNER JOIN (StaffDetails INNER JOIN (MembershipDetails INNER JOIN MemberDetails ON MembershipDetails.MembershipID = "

SQLLarge = SLQLarge & " MemberDetails.MembershipID) ON StaffDetails.StaffID = MemberDetails.StaffID) ON BranchDetails.BranchID = StaffDetails.BranchID "

SQLLarge = SLQLarge & " WHERE (((MemberDetails.MemberID)=" & vVendor & ";"

(The value of vVendor comes in from another page, this part workds fine as simplier queries do work.)

and here's my connection code:

RS.open SQLLarge, maina

Am I doing something blatantly obviously wrong? Being picking my brains out for a few hours now.

Thanks for any help offered, I'll appreciate it big time. :) :)

[ye5man]

OK, I've just found my stupid spelling mistakes **Sheepish grin**