MySQL UNION on 2 Fulltext search queries

[++Captain Tripps++]

I am trying to run a fuultext search on two identical tables and use
UNION to join the results but no matter what I try, I get a syntax
error on the UNION clause.

Here's the query:

(SELECT ID, Area_Title, Page_Description, MATCH ( Page_Description )
AGAINST ( 'searchforest tree safety' ) AS Score FROM Site_Area_Lookup
WHERE MATCH ( Page_Description ) AGAINST ( 'forest tree safety' ))
UNION ALL
(SELECT ID, Area_Title, Page_Description, MATCH ( Page_Description )
AGAINST ( 'forest tree safety' ) AS Score FROM Site_Sub_Area_Lookup
WHERE MATCH ( Page_Description ) AGAINST ( 'forest tree safety' ))

I've also tried this without the parentheses around each full select
statement.

Has anyone been able to do this?

__

++Captain Tripps++

"My name is Lucifer, please bake my ham"

[André Næss]

++Captain Tripps++:

I am trying to run a fuultext search on two identical tables and use
UNION to join the results ...
If they are identical, why do you have two tables in the first place?
... but no matter what I try, I get a syntax
error on the UNION clause.

What version are you using? Mysql 3.* doesn't support union, it wasn't
implemented until 4.0.0. See: http://www.mysql.com/doc/en/UNION.html

André Næss

[++Captain Tripps++]

On Mon, 21 Jul 2003 23:55:46 +0000, André Næss
<an*********************@ifi.uio.no> wrote:

++Captain Tripps++:

I am trying to run a fuultext search on two identical tables and use
UNION to join the results ...

If they are identical, why do you have two tables in the first place?

Well one is a parent table, and is used as a lookup for "sub" records.
These tables are referenced all over the place elsewhere in the site
nav templates or else I'd just consolidate them. Regardless, in other
areas I will be merging results from dissimilar tables which is why
UNION would have been great. Bummer.

... but no matter what I try, I get a syntax
error on the UNION clause.

What version are you using? Mysql 3.* doesn't support union, it wasn't
implemented until 4.0.0. See: http://www.mysql.com/doc/en/UNION.html

André Næss

And herein lies the problem. It's version 3.23.54.

This would have been *soooo* much easier if there were giant red
blinking letters saying (Unsupported Feature). Oh well it's the small
stuff that gets ya. Now I'll have to create a temp table and do it the
hard way.

Thanks for being kind in your response to such a boneheaded question
:-)

__

++Captain Tripps++

"My name is Lucifer, please bake my ham"