Link to home
Start Free TrialLog in
Avatar of sam shah
sam shah

asked on

automatic email alert

hi experts,

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.

thanks.
table2.PNG
table1.PNG
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial