Dynamic Query

  • Thread starter Thread starter gan
  • Start date Start date
G

gan

Hi, I'd like to know whether the following query can be made.

I've a SQL statement like the following

SELECT a, b FROM tbl WHERE a = 'something'

Anyway, the above query is "dynamic" where we do not sure the "field name"
to be retrieve is always a. Thus can we have the query something like below:

SELECT a, b FROM tbl WHERE <first field> = 'something' ??

Thanks.
 
gan said:
Hi, I'd like to know whether the following query can be made.

I've a SQL statement like the following

SELECT a, b FROM tbl WHERE a = 'something'

Anyway, the above query is "dynamic" where we do not sure the "field name"
to be retrieve is always a. Thus can we have the query something like below:

SELECT a, b FROM tbl WHERE <first field> = 'something' ??

Thanks.
Click to expand...
 
Back
Top