>

>Table1
>Date   ABal
>
>Table2
>Date   BBal
>
>How could I combine these 2 tables into one as the following format?
>
>Table3
>Date    ABal        BBal
>

select table1.*, space(x) as BBal from table1 ;
   union select table2.*, space(x) as ABal from table2 ;
   into cursor c_result

Replace the X with the width of the field in the other table. if the field is numeric, replace space(x) with a numeric representation of the field.

Ex.
N(7) - replace with 0000000