Only JOIN means what in postgres?

Question

I,m trying this query but don't know what kind join is this inner join or anything else?

select * 
FROM abc 
  JOIN xyz  on abc.id =xyz_id;

Does this answer your question? [Difference between JOIN and INNER JOIN](https://stackoverflow.com/questions/565620/difference-between-join-and-inner-join) - this is standard SQL not RDBMS dependant — Martin Smith, May 20 '20 at 09:57

score 2 · Answer 1 · edited May 20 '20 at 10:05

2

This is an INNER join. If you added the INNER keyword before JOIN, it will do the same thing. It's an optional keyword.

The following join types are listed in the PostgreSQL docs

The content in square brackets is optional in the grammar but omitting it still gives the same join type.

edited May 20 '20 at 10:05

Martin Smith

answered May 20 '20 at 10:00

Thom Brown

1 Answers1