How to formulate a cross-select query from a SQL table?

Question

SQL

There is a table with related tables defined as follows:
Pubs
.PubId
.PubName
PubNodes
.PubNodeId
.PubPtr (--> Pubs.PubId)
.NodePtr
PubTargets
.PubTargetId
.PubPtr (--> Pubs.PubId)
.TargetPtr
PubSections
.PubSectionId
.PubPtr (--> Pubs.PubId)
.SectionPtr
What would an SQL query look like to get a list of Pubs for (NodePtr = A) AND (TargetPtr = B) AND (SectionPtr = C)?
I understand that, it seems, you need to join, but I don’t understand how.

Answer 1

select *
from pubs p
    join pubnodes pn on p.pubId = pn.pubptr
    join pubtargets pt on p.pubId = pt.pubptr
    join pubsections ps on p.pubId = ps.pubptr
where (pn.NodePtr = A) AND (pt.TargetPtr = B) AND (ps.SectionPtr = C)
;