Need some help with this join

Hi,
I have the foll tables
TSTATUS
ID PRODID
111 1234
TWSTATUS
ID PRODNAME
111 TEST
SALE
ID TYPE
111 1
111 2
3PTYSALE
STID QTY PRODID
1 2 1234
2 1 9999
1 1 1234
3 1 1234
How can I display the foll
PRODID PRODNAME SUM(TYPE) COUNT(STID) SU
M(QTY)
1234 TEST 2 3 4
WHERE ID = 111
prodid,prodname,sum(type),count(stid),su
m(qty) where id = 111.
ThanksTry,
select
a.PRODID,
b.PRODNAME,
sum(c.type) as sum_type,
count(*) as count_3PTYSALE,
sum(d.qty) as sum_qty
from
TSTATUS as a
inner join
TWSTATUS as b
on a.[id] = b.[id]
inner join
SALE as c
on b.a.[id] = c.[id]
inner join
3PTYSALE as d
on c.[type] = d.stid
where
a.[id] = 111
group by
a.PRODID,
b.PRODNAME
AMB
"Chris" wrote:

> Hi,
> I have the foll tables
> TSTATUS
> ID PRODID
> 111 1234
>
> TWSTATUS
> ID PRODNAME
> 111 TEST
>
> SALE
> ID TYPE
> 111 1
> 111 2
>
> 3PTYSALE
> STID QTY PRODID
> 1 2 1234
> 2 1 9999
> 1 1 1234
> 3 1 1234
> How can I display the foll
> PRODID PRODNAME SUM(TYPE) COUNT(STID) SU
M(QTY)
> 1234 TEST 2 3 4
> WHERE ID = 111
>
> prodid,prodname,sum(type),count(stid),su
m(qty) where id = 111.
>
> Thanks