Let us I have a table name "Patient" in MS Access database and the table has following columns.
Member_ID (First Column)
Member_Name (Second Column)
Member_DOB (Third Column)
Member_Address (Fourth Column)
Member Zip (Fifth Column)
I would like to select the columns based on the column location/number/sequence than the column name.
What is the syntax in SQL to locate the column location?
Thanks for your help.
Ram
Member_ID (First Column)
Member_Name (Second Column)
Member_DOB (Third Column)
Member_Address (Fourth Column)
Member Zip (Fifth Column)
I would like to select the columns based on the column location/number/sequence than the column name.
What is the syntax in SQL to locate the column location?
Thanks for your help.
Ram