MySQL Forums
Forum List  »  Full-Text Search

Full Text four tables
Posted by: msteinblock
Date: June 03, 2006 01:25PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text four tables
2510
June 03, 2006 01:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.