Multiple unrelated table search

[manicleek]

I'm wanting to make a search facility for quite a large site
and I was wondering if theres a way to search many unrelated tables
with one SQL query.

I have looked at UNION ALL but from what I can see this can
only be used on 2 tables

[lilleman]

Hi,

I am not sure if you can use joins in this case, but it might be worth a try?

Yours, Erik.

[swampBoogie]

I have looked at UNION ALL but from what I can see this can
only be used on 2 tables

That's not true, you can have more than two.