I have a table with 3 tables, which is orderID, Detail and price.
I write a Query
SELECT * FROM [tbl];
in the result table it shows me orderID, Field0 and price(Notice Detail has changed to Field0)
How do I show Detail as it is without changing it to Field0?
Something to note:
1. I don't have right to change the table field name
2. I need to use asterick * since some columns will be added in future, and all of them need to be showed.
Thanks for the help.
I write a Query
SELECT * FROM [tbl];
in the result table it shows me orderID, Field0 and price(Notice Detail has changed to Field0)
How do I show Detail as it is without changing it to Field0?
Something to note:
1. I don't have right to change the table field name
2. I need to use asterick * since some columns will be added in future, and all of them need to be showed.
Thanks for the help.