hi all this i wrote inner join but i want for particular purchase order
what shall i add in where condtion
SELECT SINGLE
a~ernam
b~persnumber
b~addrnumber
c~smtp_addr
INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
AND b~persnumber = c~persnumber ).