Hi All,

Thanks for the replies. That is not quite what I am looking for. I want to join two tables, record per record but with no conditions. For example, I have two tables:
table A
field 1 field 2
someval someotherval
someval2 someotherval2
someval3 somotherval3

table B
Bfield1 Bfield2
bval someotherbval
bval2 someotherbval2
bval3 someotherbval3

The resulting table would look like:
TableA-B
field1 field 2 Bfield1 Bfield2
someval someotherval bval someotherbval
someval2 someotherval2 bval someotherbval
someval3 someotherval3 bval someotherbval

I can guarantee the two cursors to be joined have an equal amount of records. (so if TableA has 22 records, tableB will have 22 records and the resulting tableA-B will also have 22 records)

Thanks You,
Chris

>>Hi,
>>
>>I rarely, if ever have done full outer joins before. (basically all data in table a joined with all data in table b) I am not sure of the syntax,
>>
>>

>>select curRules.question, curRules.ansdescrip, curRules2.question2, ;
>>        curRules2.ansdescrip ;
>>	FROM curRules FULL OUTER JOIN curRules2 ;
>>	INTO CURSOR curRules3
>>

>>
>>The thing that confuses me is what I put in the 'ON' part. There are no fields that have to be equal.
>>
>>Thanks,
>>Chris
>
>If this is the case and you want the resulting table to be multiplication of the two, you can use
>

>select curRules.question, curRules.ansdescrip, curRules2.question2, ;
>        curRules2.ansdescrip ;
>	FROM curRules, curRules2 ;
>	INTO CURSOR curRules3
>