>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.