>Hello
>Select SQL gives me result with multiple repeated records. how to avoid the repeated records?
>Tables (jorders is parent table while others are childs tables)
>Jorders (Job Orders) fields (idjo, jono, descript, jodate)
>Jomatcost (JO Material cost) fields (idjo, material, qty, stdcost)
>Jompcost (JO Manpower cost) fields (idjo, employname, reghrs, reghrrate)
>Joeqpcost (JO Equipment cost) fields (idjo, equipment, equipcost)
>
>To display detail cost of each Job Order, I need the result of these tables group by jono, material, employname, equipment with total cost.
>
>The following is the command which I use to get the required result but it gives repeated records,
>
>
>SELECT Jorders.jno, Jomatcost.material, Jompcost.employname,;
> Joeqpcost.equipname, SUM(Jomatcost.qty*Jomatcost.stdcost) AS matcost,;
> sum(Jompcost.reghrs* Jompcost.reghrrate) as mpcost,;
> SUM(Joeqpcost.equipcost) AS eqpcost, SUM(Jomatcost.qty) AS qty;
> FROM ;
> main!jorders ;
> LEFT OUTER JOIN main!jomatcost ;
> ON Jorders.idjo = Jomatcost.idjo ;
> LEFT OUTER JOIN main!joeqpcost ;
> ON Jorders.idjo = Joeqpcost.idjo ;
> LEFT OUTER JOIN main!jompcost ;
> ON Jorders.idjo = Jompcost.idjo;
> GROUP BY Jorders.jno, Jomatcost.material, Jompcost.employname,;
> Joeqpcost.equipname
>
>Any alternative ?
>Regards,
vfp VERSION ?