On 2012-12-01 14:14:50 -0500, Ann Harrison wrote: > > > On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé <[1]l.r...@griensu.com> > wrote: > > > Hi, I'm wondering if there's a way to refer columns by number in WHERE > > conditions. > > > > I need this because I'm creating a generic method to create where > > clauses for hopefully ANY query, in FreePascal > > What you suggest, sir, is blasphemy. One of the major creeds of relational > theory is the separation of the logical from the physical. Codd and all > his minions will strike you down. > > On the other hand, why not just use consistent aliases? > > select > case > when (a.IDADICIONAL is null) then 'TITULAR' > else 'ADICIONAL' > end as col1, > c.idcliente as col2, c.apellido as col3, c.nombres as col4 > from clientes c > left join adicionales a on a.IDADICIONAL = c.IDCLIENTE > > > > >
Ann, column name is not the problem. What I wanted to do is to use the alias in the WHERE clause, there's no solution for this in a simple select. -- Leonardo M. Ramé http://leonardorame.blogspot.com
