Join Three Tables With One Of Them Not Having A Primary Key

I have three tables that i would like to join up together. Domain table -domainid - Primary key DomainRegion table -domainid - Don't have a Primary Key or Foreign Key -dombegin -d

Solution 1:

In addition to what I answered here, you also need to read up on the syntax of identifiers in PostgreSQL.

This:

"domain.domainid"

would have to be

"domain"."domainid"

Or better yet, simply:

domain.domainid