please help!

[itworks]

i have two tables in a database and i wish to make a third one for a search site script that i've made, but since i can't figure out how to seach in those two tables at the same time, is there a way to copy the entries on those two tables to a third one (that will contain all entries) without having to insert all one by one.

perhaps a modification in the search script to search in the two tables would be best but i can't do it.

thanks in advance.

[ebohavca]

you need to JOIN these two tables in your sql!

search for INNER JOIN / LEFT JOIN / RIGHT JOIN .. these will help you.

what db system is it?

[itworks]

i'm using MySQL.

when you say search for ..... what do you meen? search where? sorry but i'm new to this database thing.