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

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