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!