>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,
How about
SELECT item.code,item.name,list.price FROM item , list;
WHERE item.code = list.code;
AND list.code IN (SELECT code FROM list GROUP BY code HAVING COUNT(*) > 1)