>I know I've done this before but I just can't remember how...
>
>I have two tables that I want to create one cursor from. The two tables are 1 to many. In the resulting cursor I only want to show the one values ONCE, not however many records are in the child table. (this is for reporting purposes). How can I do this in a SQL statement?
>
>Any help from the SQL gurus out there would be greatly appreciated!

If it's summary report than something like that

SELECT Parenttable.*, ;
    SUM(Childtable.field1), SUM(Childtable.field2), ... ;
  FROM Parenttable JOIN Childtable ON Parenttable.PK = Childtable.FK ;
  GROUP BY Parenttable.PK ;
  INTO CURSOR ReportCursor

If you want to include child detail records

SELECT * ;
  FROM Parenttable JOIN Childtable ON Parenttable.PK = Childtable.FK ;
  INTO CURSOR ReportCursor

In the report you put parent info in the group header/footer and child info into detail band.