In my line of work I often end up working with queries where you'll have a handful of JOINs and need to SELECT a dozen or more columns. In those cases writing out staff.foo or students.bar gets old really fast.
I agree that s1 and s2 are bad though, as I said in another comment.
>In my line of work I often end up working with queries where you'll have a handful of JOINs and need to SELECT a dozen or more columns. In those cases writing out staff.foo or students.bar gets old really fast.
It's better to have it "get old" though, than to introduce subtle bugs because of similar, short, aliases.
I agree that s1 and s2 are bad though, as I said in another comment.