* [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
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
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