I think this works:
SELECT item.stock_no, equip_name, level, count(item.stock_no);
FROM stock, item;
WHERE item.stock_no=stock.stock_no;
GROUP BY item.stock_no
Thanks!
No....thank
you!
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.