search in two db tables!

[itworks]

i have two tables in a db in my site and i have a search script page for each one, but now i've changed my layout and i'd put a search form that will call a search script to search the entire site.

so i have two options either i make a new table in the db with the entries from both tables i already have or i change my search script to search in those two tables, only i can't figure out how to make it seach in two tables.

does anyone have a clue of what i should do?

thanks in advance. 🙂

[notionlogic]

You need to construct a query that JOINs the two tables together... so read the section in the MySQL manual about JOIN syntax