I want to find item that purchased from more than one supplier, so i am running following query :-
FROM Purch_Inv_Line A, Purch_Inv_Header B
WHERE A."Document No_"=B.Item and B."Posting Date" BETWEEN '2010-01-01' AND '2010-12-31'
GROUP BY A.Item
having count(distinct Vendor_Code)>1
but it is displaying only items if i run it with vendor code then it is displaying nothing in result.
Pls help me tell me how i can get both fields i will very thankful to you.