OK, you need to learn how to join tables together, and how to format code on the web. Without having access to your schema I came up with this. Also your table and column names suck.
<pre>select DISTINCT PMPRNO,PMMTNO as Material
JOIN MVXJDTA.MITBAL ON MVXJDTA.MPDMAT.PMMTNO = MVXJDTA.MITBAL.MBITNO
AND MBSUNO = 'AMER NAT'
and MBSTAT ='20'
JOIN MVXJDTA.MITSTA ON MVXJDTA.MITSTA.MHITNO = MVXJDTA.MITBAL.MBITNO
AND MHCYP6 Between 200801 and 201102
AND MHMAQT <> 0
AND MHPUQT <> 0
AND MHSOQT <> 0
AND MHUSQT <> 0
AND MHDEMQ <> 0</pre>
Also, there’s no such thing as SQL Server 2003. You either have SQL Server 2000 or SQL Server 2005.