dba123
asked on
Query repeating field
Why is this query repeating the case field multiple times for the same caseID?
select distinct c.swDateCreated, c.swCaseID, cu.swName, c.swsubject, v.vtName, cv.vtVersion, c.vtInProduction, c.swos from sw_Case c INNER JOIN vt_Component v ON c.vtComponentID = v.vtComponentID
INNER JOIN sw_Customer cu ON cu.swCustomerID = c.swCustomerID
INNER JOIN vt_Component_Version cv ON cv.vtComponentID = v.vtComponentID
WHERE c.swDateCreated >= '1/1/2005' and c.swDateCreated <= '3/31/2005'
order by c.swDateCreated, cu.swNaME
select distinct c.swDateCreated, c.swCaseID, cu.swName, c.swsubject, v.vtName, cv.vtVersion, c.vtInProduction, c.swos from sw_Case c INNER JOIN vt_Component v ON c.vtComponentID = v.vtComponentID
INNER JOIN sw_Customer cu ON cu.swCustomerID = c.swCustomerID
INNER JOIN vt_Component_Version cv ON cv.vtComponentID = v.vtComponentID
WHERE c.swDateCreated >= '1/1/2005' and c.swDateCreated <= '3/31/2005'
order by c.swDateCreated, cu.swNaME
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER