i have two tables. in table1 i have two columns (store,email),in table2 i have two columns (store,logs). In table1 ,for one particular store we have only one email id associated. but in table2 with one particular store we will have multiple logs. What i need to do is i need to send an email to that email id with which the store is attached in table1 and in the body of that email i will have the names of the logs associated with that store in table2. I need to use plsql query for this. please help me with this issue. i have attached the screenshorts of demo tables.