Self joins are used to apply column filters on that table. Alias has different purpose. Self join cannot replace Alias, and vice versa.
And for more on context and aliases use please check
Saket Asati (BOB member since 2013-07-01)
Self joins are used to apply column filters on that table. Alias has different purpose. Self join cannot replace Alias, and vice versa.
And for more on context and aliases use please check
Saket Asati (BOB member since 2013-07-01)