Newbie-Joining

[harvillo]

I have one table that searches fine but I need to add another table with the same format and be able to search them both for criteria entered by a user. What is the most efficient way? Does mysql support a UNION?

example table 1

Fruit Type | Grower
Orange | Sam

example table 2

Fruit Type | Grower
Orange | George

I would like to search both tables for criteria entered..even if I use a "LIKE" statement.

Thanks

[tomhath]

Does mysql support a UNION?

Maybe, what you have to do depends on the version of mysql you have:

http://www.mysql.com/doc/en/UNION.html