Query multiple tables
Posted: Sat Sep 30, 2006 2:15 am
Is there a way I can query multiple tables with a fulltext search and get the results back in a normal rowset.
Each table has the exact same fields just different data. Would like to search all of them at once and get one dataset instead of it adding each table to the right of the last one. Kinda like it made the 2 tables 1 table just for the search.
Each table has the exact same fields just different data. Would like to search all of them at once and get one dataset instead of it adding each table to the right of the last one. Kinda like it made the 2 tables 1 table just for the search.