>>I am trying to put together a little program to print mailing labels. The data is separated into 3 categories. The programmer before separated each category into it's own set of tables in its own folder. I want the user to be able to check boxes into include any combination of the 3 tables for printing labels. Currently I am selecting the needed info for each of the 3 categories into a cursor and then when the user clicks print I want to combine the 3 cursors into one cursor used in the label report. I can't figure out how to combine the 3 cursors into 1 cursor. Or should I go about this some other way?
>>
>>Shane Gilbert
>
>If you want to combine different fields from related tables then you run Select-SQL. If you want to concatenate three tables with identical structure then you use APPEND.

If you need to extract select records from multiple tables with identical field stuctures, you could use Select-SQL with the UNION clause. Read the online help for SQL-SELECT for more info on this.