Skip to Content
0
Former Member
Feb 16, 2009 at 01:23 PM

inner join where condition?

30 Views

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 ).