Hi, Sounds like you will need to use subqueries which is available at MySQL 4.1 and above .. See: http://www.mysql.com/doc/en/Nutshell_4.1_features.html Hope this helps. Gurhan
On Sun, 2003-06-01 at 18:30, Sparky Kopetzky wrote: > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]