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
inner join B on A.Code = B.Code where Substring(B.Voucher,1,3)= '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