have perhaps 90% of the query completed. I'm having trouble getting the dataset I need. It is a little complex to spell out but simple enough to show.
This is the request:
--I need all sales orders in house,
--I need each sales order to list the configured stain for that order.
--I also need the list price for each of those sales order.
select top 300 sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 as orderlindel,
,[url removed, login to view](cs.CFGDES_45,sod.PRTNUM_28)
from SO_Detail sod left join Configuration_Str cs on sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 = cs.CUORDR_45
where STATUS_28 < '4'
group by sod.ORDNUM_28, sod.LINNUM_28, sod.DELNUM_28, sod.PRTNUM_28, cs.cfgdes_45, sod.prtnum_28
4 pekerja bebas membida secara purata $31 untuk pekerjaan ini
We have Expert in SQL and MY SQL . We have already work in US Public safty Software like XRMS (Record Management systems) in Vb.net/sql server with crystal Reports