I need a little help with sql query.
I have the tblAuthor(authorID,surname,givenname)
I am trying to list coauthors here of given authorID.
Authors are tied to publication.
select authorID,surname,givenname from tblauthor a inner join tblAssociation b on
a.authorid=b.authorid where b.publicationid in (
select publid from association where authorid=xxx)
Is that correct?