on 11-19-2010 11:47 AM
Hi,
I have a report to which I need to add the field oitb.itmsgrpnam but not sure how to join it in, anyone's help would be appreciated.
Script as it stands:
SELECT t0.itemcode,t1.itemname, cast(t0.onhand as int) as 'Stock', cast (t0.iscommited as int) as 'Sales Orders', (cast(t0.onhand as int) - cast(t0.iscommited as int)) as 'Free Stock', t1.lstevlpric, t1.frgnname
FROM oitw t0 inner join oitm t1 on t0.itemcode = t1.itemcode
WHERE t0.whscode = '[%0]' and t0.onhand > t0.iscommited
ORDER BY t1.itemcode asc
Thanks,
Robin
Hi.........
Try this......
SELECT t0.itemcode,t1.itemname, cast(t0.onhand as int) as 'Stock', cast (t0.iscommited as int) as 'Sales Orders', (cast(t0.onhand as int) - cast(t0.iscommited as int)) as 'Free Stock', t1.lstevlpric, t1.frgnname, T2,ItmsGrpNam
FROM oitw t0 inner join oitm t1 on t0.itemcode = t1.itemcode Inner Join OITB T2 On T1.ItmsGrpCod=T2.ItmsGrpCod
WHERE t0.whscode = '%0' and t0.onhand > t0.iscommited
ORDER BY t1.itemcode
asc
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.