Trouble grouping

[Ken Alexander]

I am working with two tables customer_spec and job.
Each customer has their "typical" spec, we may do several jobs for
that customer, each job with it's own "custom" spec. I am trying to
make a report from these two tables that would look something like
this:

CUSTOMER #1
Typical Spec
Job#1
Custom spec
Job#2
Custom spec
Customer #2
Typical Spec
Job#1
Custom spec

I'm doing the grouping and ordering in the report. I can't get it to
work out. Customer and their "typical" spec are repeated with each
job. I'm very new to all this, and appreciate any help.

My sql is:

select distinct
customer_spec.notes,
customer_spec.description,
job.description,
job.notes
from component_spec
join job on job.customer_spec_id = customer_spec.id
where customer_spec.id in ( :customer_spec_id )

--
Ken Alexander
Infomaker 7.0.3
Windows2000 Prof.

"We can't solve problems by using the same kind
of thinking we used when we created them."
--Albert Einstein

[Terry Dykstra]

Don't you need to pull the customer id?

In the report make sure you sort by customer id, typical spec, job #, custom
spec, to match the group break down. Then create 4 groups, for these
columns.

--
Terry Dykstra (TeamSybase)
Techwave 2003 (PWB511: You Can Do That in InfoMaker? Cool!)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Ken Alexander" <ka...@fremontmillwork.com> wrote in message
news:OesoSITTDHA.50@forums-2-dub...