I have a pretty simple query that pulls data from 3 tables. I decided to use From and Where Clauses to Select what I want instead of Join but when I run the query it pulls duplicate data. DISTINCT was tried as well but it still pulled duplicate data.
Here is the Query -
IV00101.ITEMNMBR = IV00102.ITEMNMBR AND
IV00101.ITEMNMBR = ItmPrice.ITEMNMBR AND
IV00102.ITEMNMBR = ItmPrice.ITEMNMBR
Try this : WHERE IV00101.ITEMNMBR = IV00102.ITEMNMBR AND IV00102.ITEMNMBR = ItmPrice.ITEMNMBR group by IV00101.ITEMNMBR ORDER BY IV00101.ITEMNMBR