You need to add the table joining information the the where clause so
the join only returns properly joined records.
EX: where ta.id=tb.id
Paul Van Slyke wrote:
> Thanks for the response!
>
> The two tables contain different types of information which are related
> by a foreign key (orginally
Thanks for the response!
The two tables contain different types of information which are related
by a foreign key (orginally designed that way).However, there is no
reason that there can't be a single table that contains both (actually 3
seperate tables) sets of data. Unfortunately, building
Hi Everyone!
I've got two seperate tables that I would like to query using a MATCH ..
AGAINST() syntax. If I run the query individually on one table, the
speed of the returned results is great! Very fast, indeed. However,
when I try and use the following statement for querying both tables at
