>if you want the result in separate fields, try
>
>select * from table1, table2
I managed to delete the second half of my reply, which was
if you want them in the same field then something along the lines of :
select str(table1.fld)+str(table2.fld) from table1, table2
you may need to use alltrim & convert to numeric fields as well, depending on your required result.
Len Speed