I have a parent table and a child table, I want to get a cursor using a SELECT command containing field1 from parent table and field1 from child table plus the record number for each child record found.

Any suggestions? Thank you in advance.