dbo.v_scrap_memo_ex_bc

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_scrap_memo_ex_bc
AS
SELECT        tbl_scrap_memo_ex_bc.id_scrap_memo_ex_bc, tbl_scrap_memo_ex_bc.id_memo_scrap_hdr, tbl_scrap_memo_ex_bc.id_scrap_memo_dtl, tbl_scrap_memo_ex_bc.id_bc_in_dtl, 
                         tbl_scrap_memo_ex_bc.id_bc_in_hdr, tbl_scrap_memo_ex_bc.CAR, tbl_scrap_memo_ex_bc.BC23No, tbl_scrap_memo_ex_bc.BC23Tg, tbl_scrap_memo_ex_bc.Serial, tbl_scrap_memo_ex_bc.qty, 
                         tbl_scrap_memo_ex_bc.qty_sisa, tbl_scrap_memo_ex_bc.qty_dipakai, tbl_scrap_memo_dtl.part_no, tbl_scrap_memo_dtl.qty AS qty_vgi, tbl_scrap_memo_dtl.unit, tbl_scrap_memo_dtl.weight, 
                         tbl_scrap_memo_dtl.issue_no, tbl_scrap_memo_dtl.vgi_date, tbl_scrap_memo_dtl.vgi_qty, tbl_scrap_memo_dtl.id_data_in_dtl, tbl_data_part_hs.part_name, tbl_data_part_hs.part_name_customs, 
                         tbl_scrap_memo_ex_bc.kdsat
FROM            tbl_scrap_memo_ex_bc INNER JOIN
                         tbl_scrap_memo_dtl ON tbl_scrap_memo_ex_bc.id_memo_scrap_hdr = tbl_scrap_memo_dtl.id_memo_scrap_hdr AND 
                         tbl_scrap_memo_ex_bc.id_scrap_memo_dtl = tbl_scrap_memo_dtl.id_scrap_memo_dtl LEFT OUTER JOIN
                         tbl_data_part_hs ON tbl_scrap_memo_dtl.part_no = tbl_data_part_hs.part_no

GO