I'm following a course in databases (Standford introduction to databases on YT) and, at some point, it's mentioned that
t1 INNER JOIN t2 USING attr1, attr2 is equivalent to the NATURAL JOIN symbolized by a bow tie1 in relational algebra.
INNER JOIN … USING … expression, however, can point out what columns to use for the JOIN, while the bow tie2 operator in relational algebra does not seem to be capable of expressing that.
What is the exact representation of an SQL
INNER JOIN … USING … in relational algebra? Can someone give me an example to nudge me in the right direction?
1, 2 The bowtie with no subscript is condisered the NATURAL JOIN, while the bowtie with the condition as a subscript is considered the THETA JOIN. Here I was refering to the bowtie with no subscript.