How about:
SELECT Table1.Item, COUNT (*);
FROM Table1
INNER JOIN Table2 ON Table1.Item = Table2.Item
GROUP BY 1
ORDER BY 1
INTO CURSOR curResult
HTH
>Is it possible to write 1 select statement in VFP that will return the frequency of items across two tables. For Instance I have two separate tables that contain information about the use of a product. I want to see the total frequency of each item across the tables
>
>Table 1
>Item RespondentId SurveyId
>Item 1 1 1
>Item 1 2 1
>Item 1 3 1
>Item 2 1 1
>
>
>Table 2
>Item RespondentId SurveyId
>Item 1 1 2
>Item 2 2 2
>Item 1 3 2
>Item 2 1 2
>
>I would like 1 select statement that returns
>
>Item Freq
>Item 1 5
>Item 2 3
>
>
>Is this possible in VFP without appending the two tables first?
>
>Thanks for the help.