SQL using SELECT DISTINCT SELECTDISTINCTROOW

[TamworthBob]

How do I get only one example of a company name?





SELECTDISTINCT tblStationData.StationID, tblStationData.[Station Name], tblRepReport.RepReportID
FROM tblStationData INNERJOIN tblRepReport ON tblStationData.StationID = tblRepReport.StationID
ORDERBY tblStationData.[Station Name];



It needs to return the StationID

The query is tied to a combo box

[TamworthBob]

results:

[madpiet]

SELECTDISTINCT tblStationData.StationID, tblStationData.[Station Name], tblRepReport.RepReportID
FROM tblStationData INNERJOIN tblRepReport ON tblStationData.StationID = tblRepReport.StationID
ORDERBY tblStationData.[Station Name];

The definition of the StationData and RepReport tables would help a LOT here. To answer your question though, if you don't need any values from the child table, you can use a pattern like this:

SELECT <fields>
FROM ParentTable p
WHERE EXISTS (SELECT 1 FROM ChildTable c WHERE c.ParentRecordID = p.ParentRecordID )

and you'll get one record for each Parent table record that has any child records in ChildTable. (incredibly imaginative names, right?)