DarrenWard
IS-IT--Management
I have the following select statement, which is getting data from a table (wwo) that has a relationship on PSTK set to another table (cst). I want to get the description for the item (Desc) from the other table, but can't seem to do it.
select wwo.pstk, sum(wwo.out), wwo.req_by, sum(wwo.qty);
from wwo;
where wwo.req_by = ctod('09/10/2001');
and left(wwo.pstk, 3) = 'MWK';
and wwo.ecs_wc = _wc;
group by wwo.req_by, wwo.pstk;
order by wwo.req_by, wwo.pstk into cursor query1
All help appeciated.
Dazz (Like Harry Potter's schooling, I can't do anything without a spell checker)
select wwo.pstk, sum(wwo.out), wwo.req_by, sum(wwo.qty);
from wwo;
where wwo.req_by = ctod('09/10/2001');
and left(wwo.pstk, 3) = 'MWK';
and wwo.ecs_wc = _wc;
group by wwo.req_by, wwo.pstk;
order by wwo.req_by, wwo.pstk into cursor query1
All help appeciated.
Dazz (Like Harry Potter's schooling, I can't do anything without a spell checker)