« Information on Journal in AgEcon from Brad Teale | Main | Host Based Access on Postgres and DSPACE ... pg_hba.conf »

SQL select to get author handle data_issued and title from the postgres DB

select itemsbytitle.title , handle.handle, itemsbydate.date_issued , itemsbyauthor.author
from (( itemsbytitle
INNER JOIN handle ON itemsbytitle.item_id = handle. resource_id)
INNER JOIN itemsbydate ON itemsbydate.item_id = itemsbytitle.item_id)
INNER JOIN itemsbyauthor ON itemsbyauthor.item_id = itemsbytitle.item_id
where resource_id = 8137;

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)