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

>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
>