FROM invoucher inner join invoucherdetail ON invoucher.ID=invoucherdetail.voucher inner join Warehouse ON (CASE INVoucher.EntryType WHEN IN0001; THEN INVoucher.ToWarehouse WHEN IN0002 THEN INVoucher.FromWarehouse ELSE INVoucher.FromWarehouse END ) = Warehouse.ID ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip