Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Our SQL interview questions. Parent comment
I'd rather see:
EmployeeReferences eFrom JOIN EmployeeReferrals eTo
ON eFrom.ID = eTo.ID ... JOIN xyz ON eFrom.Source = ...
Similarly, I've had to deal with (admittedly legacy) tablenames like A12R18SALE and A12B14PROD. Aliases come in really handy there.
There are no comments on this comment yet.
I'd rather see:
...and then see rather than have to read acres of EmployeeRe-something 4 or 5 times through an 8-table BI join.Similarly, I've had to deal with (admittedly legacy) tablenames like A12R18SALE and A12B14PROD. Aliases come in really handy there.