Inner Join error 1

[ZOR]

I get a missing operator message comming up with this query typed in a query grids SQL page. Can someone advise, thanks

FROM TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1 = TXCLIPS.ID1 INNER JOIN KEYWORDS ON TXCLIPS.Comments Like "*" & KEYWORDS.keyword & " *";

Cannot find reference to anything that goes between joins, tried &, AND, Alao removed INNER, and JOIN on second join part but it errord. Thanks

 

[PHV]

FROM [!]([/!]TXMASTERS
INNER JOIN TXCLIPS ON TXMASTERS.ID1 = TXCLIPS.ID1[!])[/!]
INNER JOIN KEYWORDS ON TXCLIPS.Comments Like "*" & KEYWORDS.keyword & " *"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZOR]

Many thanks PHV, have a star, it works. Regards