Multi-part identifier in SQL

See more:

SQL

SQL-Server-2008R2

i tried query to fetch results but when i execute query this shows me following error

The multi-part identifier "material .MATNO" could not be bound.

The multi-part identifier "plant.plant" could not be bound.

any solution?

What I have tried:

i tried this query
SELECT
customer.custm_no, customer.name,customer.name2,

orderhdr.otype,orderhdr.saleorder,

orderdtl.sitno,orderdtl.qty,

delvdtl.qty,delvdtl.issueqty

material.name,develhdr.nodelv

FROM
customer

left join orderhdr on customer.custm_no = orderhdr.custm_no
left join orderdtl on orderhdr.otype = orderdtl.otype
and orderhdr.SALEORDER = orderdtl.SALEORDER
left join delvdtl on orderdtl.SALEORDER = delvdtl.SALEORDER
AND orderdtl.sitno = delvdtl.sitno
left join develhdr on delvdtl.nodelv = develhdr.nodelv
left join MATMSTA on material.MATNO = MATMSTA.MATNO
left join material on MATMSTA.MATNO = material.MATNO
and MATMSTA.MATNO = material.MATNO
left join plantcocode on plant.plant = plantcocode.plant
left join plant on orderdtl.plant = plantcocode.plant
left join cocode on plantcocode.cocode = cocode.cocode
WHERE
1 = 1
order by
orderdtl.saleorder, orderdtl.sitno