Using a select query to rename a column name?

ets960

Registered User.
Local time
Today, 02:37
Joined
Jun 2, 2005
Messages
21
Is there any way to use a select query where it will select the values off of my database but temporarily use a different column name for one of the columns???

I have 3 different item names stored in my main table. When I compare this to another table, I want to select one of the item names and just pass that as item_name. This way, I can have the same compare routine instead of writing a different compare routine for each item name. Any way? Thanks a lot for the help in advance!
 

Users who are viewing this thread

Back
Top Bottom