Trying to flip some data around...

SELECT ;
	KeyField, ;
	MyField01, ;
	MyField02 ;
	FROM MyTable ;
	WHERE MyTable.KeyField == m.KeyExpression ;
	INTO CURSOR MyCursor

The output is like this:

KeyField     MyField01     MyField02

000001       Smith         Jones

The results I want to get is:

KeyField     MyField

000001       Smith
000001       Jones