4 ms·
I'm not a sql expert but I've used sql for over 20 years and I think I've only used one type of join. It's not even syntactically specified as a JOIN- just SEL
by dekhn 5y ago
I'm not a sql expert but I've used sql for over 20 years and I think I've only used one type of join. It's not even syntactically specified as a JOIN- just
SELECT * FROM a, b, c WHERE a.id = b.fid AND b.id = c.fid
I think this is known as an INNER JOIN? I dunno, I came from science where cross product and filtering are approached in a very different way.