Let's say I have a query that performs "select * from Account"
one of the columns from "Account" (city) is actually a key which may be either numeric or character. There is a table called "City" which contains keys and names of cities. and I want the City.Name value where Account.city matches City.ID. I need the most efficient way to do this: examples, keywords, and URLs to relevant documentation are all welcome. thanks tim -- Tim Johnson <[EMAIL PROTECTED]> http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]