Tricky Distinct Query

J

Joel

I have about 50 fields that i need selected but I just need to omit
duplicates in one field. ([MainUnitData.Description1])
I have tried to use SELECT DISTINCT but its not coming out the way I need it
too.

Here is my SQL Statement:

SELECT MainAreaData.FacilityOwner, MainAreaData.FacilityOwnerID,
MainAreaData.FacilityName, MainAreaData.FacilityID, MainAreaData.AreaName,
MainAreaData.AreaID, MainAreaData.UnitName, MainAreaData.UnitID,
MainUnitData.UnitID, MainUnitData.InspectionFrequencyID,
MainUnitData.InspectionFrequencyName, MainUnitData.StructureTypeID,
MainUnitData.StructureTypeName, MainUnitData.YearInstalled,
MainUnitData.StructureStatusID, MainUnitData.StructureStatusName,
MainUnitData.StructureMaterialID, MainUnitData.StructureMaterialName,
MainUnitData.StructureUsageID, MainUnitData.StructureUsageName,
MainUnitData.UnitName, MainUnitData.StructureID, MainUnitData.Description1,
MainUnitData.Description2, MainUnitData.Remarks, MainUnitData.NoActionReq,
MainUnitData.ImplementMaintenanceRepairs,
MainUnitData.PreformAdditionalInspections,
MainUnitData.PreformEngineeringAnalysis,
MainUnitData.DevelopRemedialDesignDetails,
MainUnitData.FurtherInvestigationReq, MainUnitData.[Adj Inspection Freq
Increase], MainUnitData.[Adj Inspection Freq Decrease],
MainUnitData.OtherExplain, MainUnitData.Explain,
MainUnitData.InspectionTypeName, MainUnitData.InspectionTypeID,
MainUnitData.InspectionDate, MainUnitData.NextInspectionDate,
MainUnitData.PeriodType, MainUnitData.Frequency,
MainUnitData.NextInspectionType, MainUnitData.NextInspectionTypeID,
MainUnitData.GeneralDiscription, MainUnitData.EstManHours,
InspectionHistory.Date, InspectionHistory.InspectionTypeName,
InspectionHistory.InspectionTypeID, InspectionHistory.CGAName,
InspectionHistory.CGAID, InspectionHistory.AgentName,
InspectionHistory.AgentProjectID, InspectionHistory.BPWorkOrderID,
InspectionHistory.InspectionID, InspectionHistory.StructureID,
InspectionHistory.Good, InspectionHistory.Fair, InspectionHistory.Poor,
InspectionHistory.Indeterminate
FROM (MainAreaData INNER JOIN MainUnitData ON MainAreaData.UnitID =
MainUnitData.UnitID) INNER JOIN InspectionHistory ON MainUnitData.StructureID
= InspectionHistory.StructureID;


Thanks!
 
Top