is it possible to use a full-text search query on two tables at the same time? for example, say i have a table of items, and another table of descriptions... would i be able to search both those tables for a string in one query? they are currently in indexed in separate catalogs, would i need to put them both in one?
thanksUse subqueries, maybe even with UNION [ALL] if the result set will contain the same number of fields in the same order, and of the same data types.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment