select LOC_CODE, LOC_STAT, from M_LOC where comp_Code = 'A1' and Whse_code = '8' and loc_code like '28-%' 28-11-01 A 28-11-02 A 28-11-03 A 28-11-04 A 28-11-05 A
select LOC_CODE, Cust_code from C_LOC where comp_Code = 'A1' and Whse_code = '8' and loc_code like '28-%' 28-11-01 BVFTOR 28-11-03 BVFTOR
select M.LOC_CODE, C.CUST_CODE from M_LOC M LEFT OUTER JOIN C_LOC C on M.COMP_CODE = C.COMP_CODE and M.WHSE_CODE = C.WHSE_CODE and M.LOC_CODE = C.LOC_CODE where M.comp_Code = 'A1' and M.Whse_code = '8' and M.loc_STAT = 'A' and M.loc_code like '28-%' 28-11-01 BVFTOR 28-11-03 BVFTOR
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.