group by clause
hi,
i need to fetch information from difrrent tables i made querry showed below but the problem arise
that when i remove GROUP BY clause it showing me all records but when i add GROUP BY clasue
and try to fetch information it doesnt show anything just empty records anyone have idea to deal with this pleas discuss
Thank u.
select batches,gmh1.BATCH_NO FIRM_NO,RO.ROUTING_DESC,RE.RECIPE_DESCRIPTION,RE.RECIPE_VERSION
, MTL.DESCRIPTION INGREDIENTS,quantity,uom,actual_usage,QUANTITY_VARIANCE, variance_percentage
,batch_size,product_name
from gme_batch_header gmh
, gme_material_details gmd
select batches,gmh1.BATCH_NO FIRM_NO,RO.ROUTING_DESC,RE.RECIPE_DESCRIPTION,RE.RECIPE_VERSION
, MTL.DESCRIPTION INGREDIENTS,quantity,uom,actual_usage,QUANTITY_VARIANCE, variance_percentage
,batch_size,product_name
from gme_batch_header gmh
, gme_material_details gmd
0