I have a view I need to create from several tables where I'm looking up one
value from a table and need to add it to the Select stmt like this:
SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id =
bite.bite_animal_sex_id),
type (SELECT type_meaning FROM type WHERE type_id =
bite.bite_type_id), etc...
However, I haven't found an example of how to do this and I need this
ASAFP!!
Apreciate any help.
Robin E. Kopetzky
Black Mesa Computers/Internet Services
www.blackmesa-isp.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
