Hi all, i need an sql to get the list of items that have 2 or more price but not wich have only 1 price. I'm doing this: select i.code,i.name,l.vendor,l.price from list,item where i.code=l.code , this sql returns all items with all prices in list but i need only the items that have more than 1 record in list, so i make another sql to have the code: select code,count(1) as total from query, next i get the code for total=1 and delete them in first sql. There is a way to doit with just 1 line in sql?
Thanks in advance,