Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Only want unique records.

    Sorry for the white noise. Fixed it myself.

    SELECT DISTINCT incidents.*

    FROM incidents INNER JOIN responses ON incidents.incidentid = responses.incident

    WHERE (((responses.replydate)>[incidents].[dateaccessed]) AND ((responses.incident)=[incidents].[incidentid]) AND ((incidents.userid)=) AND ((incidents.closed)=0));

    too simple really...

Viewing post 1 (of 2 total)