dnet40/modules/dnet-information-service/trunk/src/main/resources/eu/dnetlib/enabling/is/templates/obtain_notifications.sql.st @ 34408
| 1 |
select
|
|---|---|
| 2 |
n.tbl, |
| 3 |
n.operation, |
| 4 |
n.date, |
| 5 |
n.new, |
| 6 |
n.old, |
| 7 |
s.subscriber, |
| 8 |
s.condition |
| 9 |
from
|
| 10 |
notifications n left outer join subscriptions s on (n.tbl = s.tbl and n.operation = s.operation) |