| | |
|
|
|
Duplicate results in query |
|---|
| message from Zwi2000 on 24 Jul 2004 |
I have the query below, problem is that sometimes results are duplicated, I
need to display unique results. In this case "a.id" is the unique Id that I
need to use not to duplicate the records, how can I modify the query to do
this ?
SELECT a.id,a.caseid, b.FirstNm, b.LastNm, e.Processcatalog, b.I94DateD,
a.ExpDate,a.maincase,a.caserelationship, f.MaidenNm, a.approvaldate
FROM cases a Inner join users as b on a.alienid = b.userid Inner join
Processcatalog as e on a.process = e.ProcesscatalogID left join Users as f
on a.empid = f.userid left join Activities as g on a.id = g.caseid
WHERE a.firmid = 1 AND g.acttype = 'history' AND (g.Lastmodified IS NOT
NULL AND g.Dateinitiated IS NULL)
Thanks for the help !
Z
|
|
Archived message: Duplicate results in query (Macromedia Dreamweaver Web Design)
