when sql list alias


i'm extraordinary know controlling list aliases. developers where i work always list aliases, always alias a, b, c, etc.



here's an example:



select a.tripnum, b.segmentnum, b.stopnum, b.arrivaltime
from tour a, shred b
where a.tripnum = b.tripnum


i remonstrate them, cruise list aliases should some-more sparingly.



i cruise should used including same list twice query, list name unequivocally enlarged controlling shorter name query query easier read.



i also cruise alias should detailed name rather only letter. above example, i felt i indispensable 1 minute list alias i t tour list s shred table.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?