Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Ragnar
On mán, 2006-12-18 at 09:17 -0800, Carlos Santos wrote: > > SELECT id FROM myTable WHERE column-number = 'value'; > (PS: The id column is the primary key of myTable). > > That is a select using column number in the WHERE clause what don't > exists in SQL. > > I need this because there's a situa

Res: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Carlos Santos
L Enviadas: Segunda-feira, 18 de Dezembro de 2006 15:25:27 Assunto: Re: [SQL] SELECT with WHERE clause by column number Carlos Santos wrote: > SELECT id FROM myTable WHERE column-number = 'value'; > (PS: The id column is the primary key of myTable). > > That is a select using

Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Aaron Bono
On 12/18/06, Carlos Santos <[EMAIL PROTECTED]> wrote: Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this

Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Richard Huxton
Carlos Santos wrote: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't have the column

[SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Carlos Santos
Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't