Advanced Search In Multiple database tables

[Doddsey_65]

Hi All

I am trying to modify the advanced search but to no avail.

I want it so that when a product is searched for it will search several product tables that i have in the same database.

Eg/

Customer searches for TEST
Search engine searches DATABASE
Search engine searches through TABLE_PRODUCT1
Search engine searches through TABLE_PRODUCT2
Then displays result and which table the info was pulled from.

Does anyone know of a way to do this?
Thanks

[Doddsey_65]

I found this in advanced_search_result/header.php

$from_str = "FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m
USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c )

LEFT JOIN " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd
ON mtpd.products_id= p2c.products_id
AND mtpd.language_id = :languagesID";

Is there something I could do with that?
I have tried this:

$from_str = "FROM (" . TABLE_PRODUCTS && TABLE2_PRODUCTS . " p

but that brings up an error.