Dynamic Query

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top