>Dear Experts,
>
>I have header table and detailed table, i want to retrive all the data from header table
>+ and the data from datailed table in which heder id = detailed id.
>
>A-> Header table
>B-> Detailed table
>
>select A.code, A.Desc, B.Cost, B.Qty from A
LEFT join B on A.Code = B.Code AND B.Voucher LIKE 'ABC%'
>
>this is retriving all the datas which are commen in both tables,
>but i want retrive all the data same as above + some items are in header table
>which are not participate in transactions(These items are can not find in detailed file).
>
>Or, for Exmaple
>
>Header Table -> 10 rows
>Deatled Table -> 6 rows
>
>Resulted table should contain 16 rows with contions as above
>
>How will do it, pls help
>
>Thanks in advance
>
>Regards
>Abdulla