I have two tables .
A1 and L1
A1 has
address
sort_no
L1 has
Address
lifnr.
I want to get lifnr depending on sort_no. in a single select number.
How to get it.
