On Mon, 2002-12-09 at 20:58, Chris Jewell wrote:
> ...
> 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 c
sage -
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: "Chris Jewell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 9:08 PM
Subject: Re: [SQL] Problem with a lookup table! Please help.
Chris,
> In my capacity as a vet student, I
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 tab
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 w
Hi,
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 wo
