Re: Select from where? (Primary keys?)

[Margaret MacDonald]

You can do what you're trying to do, but it'll be more work than a single statement. You have to first issue a DESCRIBE query on the table. That will return a dataset with a record for each field (do a DESCRIBE on a table in the commandline window and you'll see the format). Once you have that dataset, loop through each of the field-description records looking for "PRI" in the 'key' field. When you find that, you can get the fieldname from the "Field" field and go on from there.