macromedia.coldfusion.getting_started
[Top] [All Lists]

Group By Query Problem

Subject: Group By Query Problem
From: "eziokolo"
Date: Mon, 16 Jun 2008 19:41:20 +0000 UTC
Newsgroups: macromedia.coldfusion.getting_started

This is my Query 
 SELECT 
p.partno,p.vendornumber,p.Type,p.Modelname,p.Modelnum,p.modelyear,p.description
        FROM Parts_all p INNER JOIN Contacts c ON p.vendornumber = c.ID
        Where p.partno = '602510'
        Group by 
p.partno,p.vendornumber,p.Type,p.Modelname,p.Modelnum,p.modelyear,p.description

 Because the Modelname, description and Modelyear have different values, the 
above Query returns multiple partno and Vendornumber for record.

 What I would like to accomplish is to filter the records to return only one 
record where the Partno and vendornumber are the same.

 Please help with examples.

 Thanks


<Prev in Thread] Current Thread [Next in Thread>