help in select query
in my selection screen i have a email button. it allows for entering multiple mail ids.
my requirement is if user does not enter any mail id then it should
get the email address from the KNA1/ADR6 combination and populate it in to the email ID window
if found blank throw a error.
how to code the select statement so that i can get the mail id from KNA1/ADR6 these two table combination.