How to union table without union statement?

Hi,<br /><br /> I need to combine 10 tables which contain same table structure and join an "other table" to show the
latest200 record, I am join the "other table" first and using union statement to select all record now but the
collectiontime is super slow, how can I improve the collection speed?<br /><br /> Thanks.<br clear="all" /><br />-- <br
/>Jr.P<br />calendarw