General information
Category:
Coding, syntax & commands
Title:
SQL Statment Needed
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only