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
Post a Comment