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]

Reply via email to