Re: [GENERAL] SQL Join for a Calculation

You want to do count(DISTINCT part_id) and count(DISTINCT desc). On Sat, Nov 11, 2006 at 04:25:51PM -0800, Kojak wrote: Here's a description of the scenario. The question I'm asking follows the description. 3 tables table1: job_no int4 rate1 float4 qty1 float4 rate2 float4 qty2 float4

[GENERAL] SQL Join for a Calculation

Here's a description of the scenario. The question I'm asking follows the description. 3 tables table1: job_no int4 rate1 float4 qty1 float4 rate2 float4 qty2 float4 rate3 float4 qty3 float4 table2: job_no int4 part_id int4 rate float4 qty float4 table3: job_no int4 desc varchar(32) rate float4