How to do an inner join

Forum|Forum|3 years ago
August 20, 2023
15 replies
486 views

Hello, I would like to join two tables with the id as a key using the inner join, but when I try to do so, it doesn’t return any results even though it should return something. I woule like to know what is the correct syntaxis for this, I am using

SELECT * FROM "Table1" INNER JOIN "Table2" ON 'Table1.Table2_id' = 'Table2.id';

Thank you!

Developer

Show previous replies

S

ShivC_1

Navigator | Tier 3

Postgres is case-sensitive. Is the field names and table names identical?
SELECT *
FROM "People"
INNER JOIN "MasterPeople" ON "People"."MasterPeople_idPerson" = "MasterPeople"."idPerson";

V

valenpalacio930Author

Cadet | Tier 2

Yes, the names are identical. As an example when I use just the select * and the name of the tables it works perfectly, the issue is with this inner join

S

ShivC_1

Navigator | Tier 3

what about the field names?

V

valenpalacio930Author

Cadet | Tier 2

Yes, everything is identical. I made sure of it several times

S

ShivC_1

Navigator | Tier 3

Can you give me a Select query with the fields of the table individually with *?