>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao