Hi to All,
i have a table

tbl1:
scode
c1
c2
c3
c4
...
and

tbl2

scode item qty
c1 itm4 1
c2 itm2 2
c3 itm3 1
c4 itm1 4
....

my problem is how to join this 2 tables in this format ;

tbl3

scode item qty
c1 itm1 0
c2 itm1 0
c3 itm1 0
c4 itm1 4
...
c1 itm2 0
c2 itm2 2
c3 itm2 0
c4 itm2 0

iwant to pick all scode with the same item.

tnx
Ryan