Oracle Confusion

Hi

I have a master table emp/dept and I need to display the data using a query that infuses the criteria of the scott database. I need to display the empno, ename of every salesman and the total number of products say 'Tennis Rackets' they have sold.

How would I do this? Would it be a join or a subquery?

Thanks

Smiler

You dont need neither subquery nor join for this particular query.

SEECT empno, ename, count(*)
FROM emp, sales
WHERE empno = repid
AND proid = 101860
GROUP by empno, ename
/

Hi

The tables being used are:

The normal emp/dept tables. The other tables are:

Bonus(ename,job,sal,comm)

Salgrade(grade,losal,hisal)

Customer(custid,name,address,city,state,zip,area,phone,repid,creditlimit,comments)

Ord(ordid,orderdate,commplan,custid,shipdate,total)

Item(ordid,itemid,prodid,actualprice,qty,itemtot)

Product(prodid,descrip)

Price(prodid,stdprice,minprice,startdate,enddate)

These are the tables I have...you mentioned sales for a couple of the queries, but there is no sales schema - what would it be instead of sales?
Would it be repid/cust id?