Re: [SQL] Using count on a join, group by required?

2010-12-14 Thread emaratiyya
Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records. Product (product_id, product_name, supplier_name, quantity, price_per_unit) You are required to create PL/SQL package that achieves the following functionalities: •

Re: [SQL] Using count on a join, group by required?

2010-12-14 Thread Trinath Somanchi
what are the inputs to the PL-SQL procedure. On Tue, Dec 14, 2010 at 12:49 PM, emaratiyya emarati...@hotmail.com wrote: Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records. Product (product_id, product_name,

Re: [SQL] Using count on a join, group by required?

2010-12-14 Thread Rob Sargent
Shouldn't you be doing your own homework? emaratiyya wrote: Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records. Product (product_id, product_name, supplier_name, quantity, price_per_unit) You are required to create

Re: [SQL] Using count on a join, group by required?

2010-12-14 Thread Rob Sargent
If you showed your work, you might get decent hints if not solutions. On 12/14/2010 09:23 AM, Rob Sargent wrote: Shouldn't you be doing your own homework? emaratiyya wrote: Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary

Re: [SQL] Using count on a join, group by required?

2010-08-11 Thread Peter Eisentraut
On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote: And it works, it gives me something like: product_id | name | code | manufacturer_id | manufacturer_name | num_serials

Re: [SQL] Using count on a join, group by required?

2010-08-11 Thread Jose Ildefonso Camargo Tolosa
On Wed, Aug 11, 2010 at 8:09 AM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote: And it works, it gives me something like:  product_id |         name         |     code      | manufacturer_id |     manufacturer_name      |

[SQL] Using count on a join, group by required?

2010-08-10 Thread Jose Ildefonso Camargo Tolosa
Greetings! First: This is working, I just need a clarification on concept, so, it is not necessary for you to look deeply at the SQL statement. I have this: Table: products that references manufacturer via products.manufacturer_id to manufacturer.id (not important, just informative). Table: