Revision 48139
Added by Alessia Bardi almost 7 years ago
| find_journal_intersection.sql | ||
|---|---|---|
| 1 |
select |
|
| 2 |
h.entry as id, |
|
| 3 |
h.datasourceid as datasource, |
|
| 4 |
d.officialname as name |
|
| 5 |
|
|
| 6 |
from hostedby_map h, datasources d where |
|
| 7 |
h.oa_source_id= 're3data_____::r3d100010134' AND |
|
| 8 |
h.datasourceid = d.id |
|
| 1 |
SELECT |
|
| 2 |
h.entry AS id, |
|
| 3 |
h.datasourceid AS datasource, |
|
| 4 |
d.officialname AS name |
|
| 5 |
|
|
| 6 |
FROM hostedby_map h, datasources d |
|
| 7 |
WHERE |
|
| 8 |
h.oa_source_id = 're3data_____::r3d100010134' AND |
|
| 9 |
h.datasourceid = d.id |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40