look up - Query - grouping

  • Thread starter Thread starter Deena
  • Start date Start date
D

Deena

I need to create a query that groups all the like #'s -
For example - client ID's and display the line items
associated with those id's
 
YOu need to join the two tables together using a common field
(PrimaryKey to ForeignKey is best)
then order by the field you want to use to group the data with
See below for an example

SELECT tblCountry.ID, tblCountry.Country, tblCampDet.CampQtrNum,
tblCampDet.CampYear, tblCampDet.TVT
FROM tblCountry INNER JOIN tblCampDet ON tblCountry.ID =
tblCampDet.CountryID
ORDER BY tblCountry.ID;
 
Back
Top