I know some of SQL but, I always use join
, left
, cross
and so on, but in a query where the tables are separated by a comma. It's looks like a cross join to me. But I don't know how to test it (the result is the same with the tries I made).
SELECT A.id, B.id
FROM A,B
WHERE A.id_B = B.id
Even in the great Question (with great answers) "What is the difference between Left, Right, Outer and Inner Joins?" I didn't find an answer to this.
It would be a cross join if there wasn't a WHERE
clause relating the two tables. In this case it's functionally equivalent to an inner join (matching records by id_rel
and id
)
It's an older syntax for joining tables that is still supported in most systems, but JOIN syntax is largely preferred.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With