Re: Search Query

[Peter Brawley]

Quote

(SELECT * FROM donations)
UNION ALL
(SELECT * FROM single)
UNION ALL
(SELECT * FROM shoes)
UNION ALL
(SELECT * FROM groupForm)
ORDER BY postingTitle;

Only if the four tables are union-compatible, ie close-to-identical in structure, but if they are, then you should very likely have one table with one column indicating "type" or whatever property distinguishes your current four tables.

PB