SQL Full Text

[alirezaok]

see this sql:

SELECT * 
FROM DYNAMIC
WHERE MATCH (
DYNAMIC.title, DYNAMIC.intro
)
AGAINST (
'salam'
IN BOOLEAN
MODE 
) 

this sql work correctly but i need to select from 2 table:

SELECT * 
FROM DYNAMIC, STATIC
WHERE MATCH (
DYNAMIC.title, DYNAMIC.intro, STATIC.content
)
AGAINST (
'salam'
IN BOOLEAN
MODE 
) 

but this SQL doesn't work.
(also there is not any relation beetween 2 tables)
any one can correct this sql?

[alirezaok]

any idea ?!

[Roger_Ramjet]

Can't have a full text index, or any index really, across multiple tables so you can't do that. If there is no relation between the 2 tables then the most efficient way if with a UNION QUERY. You will need to create a full text index on the second table as well.

[alirezaok]

thre is full index on both of tables because this sql work too:

SELECT * 
FROM  STATIC 
WHERE MATCH ( 
STATIC.content 
) 
AGAINST ( 
'salam' 
IN BOOLEAN 
MODE 
) 

also i cann't use of union query because number of fields in 2 tables is not equal

[Roger_Ramjet]

So make them equal by specifying only the cols you want instead of *, or adding dummy cols to the smaller table. Otherwise it's 2 queries.