Thursday, December 23, 2010

Table aliases are required when

Table aliases are required when … Example
a table is joined to itself (called a self-join or reflexive join)
from airline.staffmaster as s1, 
airline.staffmaster as s2
you need to reference columns from same-named tables in different libraries
from airline.flightdelays as af, 
work.flightdelays as wf
where af.delay > wf.delay

No comments:

Post a Comment