Re: [SQL] Problem with a lookup table! Please help.

2002-12-09 Thread Chris Jewell
mple, 1 => Excellent, 2=> Good, etc etc. What I need to do is to substitute the integers set in the "Activity..." columns in tblantibiotics with the strings in 'Plain_english' according to the integer set in 'Efficacy_code'. Any ideas? Chris J - Original Mes

[SQL] Problem with a lookup table! Please help.

2002-12-09 Thread Chris Jewell
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