A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
2 added 4 characters in body
source | link

The first onequery is the same as an innerINNER joinJOIN, the second onequery is not valid because it is using ON without a JOIN statement.

From a similar question:

The comma operator is equivalent to an [INNER] JOIN operator. The comma is the older style join operator. The JOIN keyword was added later, and is favored because it also allows for OUTER join operations

Source

Testing db<>fiddle

The first one is the same as an inner join, the second one is not valid because it is using ON without a JOIN statement.

From a similar question:

The comma operator is equivalent to an [INNER] JOIN operator. The comma is the older style join operator. The JOIN keyword was added later, and is favored because it also allows for OUTER join operations

Source

Testing db<>fiddle

The first query is the same as an INNER JOIN, the second query is not valid because it is using ON without a JOIN statement.

From a similar question:

The comma operator is equivalent to an [INNER] JOIN operator. The comma is the older style join operator. The JOIN keyword was added later, and is favored because it also allows for OUTER join operations

Source

Testing db<>fiddle

1
source | link

The first one is the same as an inner join, the second one is not valid because it is using ON without a JOIN statement.

From a similar question:

The comma operator is equivalent to an [INNER] JOIN operator. The comma is the older style join operator. The JOIN keyword was added later, and is favored because it also allows for OUTER join operations

Source

Testing db<>fiddle