Re: "linking" rows

2006-02-23 Thread Tim Johnson
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [060223 09:09]: > Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM: > > I need the most efficient way to do this: examples, keywords, and > > URLs to relevant documentation are all welcome. <> > First off, columns can either be numeric or

Re: "linking" rows

2006-02-23 Thread SGreen
Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM: > 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

"linking" rows

2006-02-23 Thread Tim Johnson
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 C