>>Working in VFP60... I want to get a result query that is based on a
>>SET RELATION. The common fields are part_number.
>>My result query should have the following information.
>>
>>Common Part number........parts_sold _in_1999.....parts_sold_in_2000
>>102.....................................230.............................400
>>
>>Any Ideas?
>
>Relations have no bearing on SQL Select result sets. You define how you want the two tables to "relate" to one another in the WHERE or the JOIN clause.
>
>Also, from the looks of your example result, you may want to look at the aggregate functions for SQL (e.g. SUM) and the help on the GROUP BY clause.
>
>HTH.
-----
yea, I see what you mean...In this case, I can use the JOIN.. thanks..:)