From: Jean-Luc Lachance <jllachan@nsd.ca>
To: josh@agliodbs.com
Cc: Chris Jewell <vs0u8055@liv.ac.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with a lookup table! Please help.
Date: Mon, 09 Dec 2002 16:34:38 -0500
Message-ID: <3DF50C6E.2D94936D@nsd.ca> (raw)
References: <000f01c29fc5$afc34960$2301a8c0@chrisdomain>
<200212091308.34332.josh@agliodbs.com>
Use the AS keyword to introduce a column alias.
Select thisverlongtablename.thefirstfield as title, ... from
JLL
Josh Berkus wrote:
>
> Chris,
>
> > In my capacity as a vet student, I'm trying to create a database of
> antibiotics. The way that I have set it up so far is to have one main table
> listing the antibiotics versus their respective efficacies against the four
> major groups of bacteria. Due to the way that my PHP frontend works, I have
> assigned a number to the efficacy - 1 being excellent and 5 being poor
> efficacy against the particular bacterium. However, I now want to have a new
> table which converts numbers into words. The problem is this, if I join the
> main table with the "translation" lookup table, the column names for each of
> the four categories in the main default to the column name in the lookup
> table and hence are all the same. What SQL expression should I use to
> translate the cryptic numbers into plain english whilst preserving the column
> headings in the main table?
>
> Please post your table definitions as SQL statements.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jllachan@nsd.ca, josh@agliodbs.com, vs0u8055@liv.ac.uk
Subject: Re: Problem with a lookup table! Please help.
In-Reply-To: <3DF50C6E.2D94936D@nsd.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox