Full Text four tables

[msteinblock]

I have four tables, each indirectly linked to one another. I am trying to do a full text search from those four tables with the following:

SELECT DISTINCT Roster.RosterID AS RosterID,
MATCH( City ) AGAINST('%1%') OR
MATCH( State ) AGAINST('%1%')OR
MATCH( Remarks ) AGAINST('%1%')
FROM Photos INNER JOIN Roster ON Photos.RosterID = Roster.RosterID WHERE MATCH( FirstName ) AGAINST('%1%')OR
MATCH( LastName ) AGAINST('%1%')
FROM Users INNER JOIN Photos ON Users.UserID = Photos.UserID
WHERE MATCH( LocoID ) AGAINST('%1%')OR
MATCH( Model ) AGAINST('%1%')OR
MATCH( SerialNumber ) AGAINST('%1%')OR
MATCH( FrameNumber ) AGAINST('%1%')OR
MATCH( BuilderDate ) AGAINST('%1%')OR
MATCH( Lineage ) AGAINST('%1%')OR
MATCH( Notes ) AGAINST('%1%')
FROM Roster INNER JOIN Photos ON Roster.RosterID = Photos.RosterID WHERE MATCH( ReportingMark ) AGAINST('%1%')OR
MATCH( RoadName ) AGAINST('%1%')OR
MATCH( Category ) AGAINST('%1%')
FROM Roads INNER JOIN Roster ON Roads.RoadID = Roster.RoadID

I am getting an error:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Users INNER JOIN Photos ON Users.UserID = Photos.UserID WH


Any ideas if 1) this is possible and 2) what the problem is in this sytax?

Thanks for the help! It is much appreciated.

~Matthew