That certainly looks like an inner join... but, it's not... behind the scenes, you end up with the same thing as a cross-join because of the criteria you've specified.
It will, however, deceive a DBA that's in a hurry 😀
--Jeff Moden
Change is inevitable... Change for the better is not.