On 17-Nov-2003, [email]redhatlinuxmsn.com[/email] (aaron) wrote:
select flavors from nametable,icecreamtable where favorite=icecreamtable.key> I have a question about (i think) joining.
> If I have a table in a database that has this info:
> key - name - favorite
> 1 - john - 2
> 2 - judy - 3
> 3 - joe - 1
> the favorite icecream table is this:
> key - flavors
> 1 - vanilla
> 2 - chocolate
> 3 - strawberry
> how do i do a query to display that judy's favorite is strawberry.
> obviously this is a simple example. i am doing working on something
> that is much more complex than this, but if anyone can give a hint i
> can apply to the thing i am working on.
tom (at) creative (dash) light (dot) com
do NOT send email to [email]jamesbutlerwillglen.net[/email] (it's reserved for spammers)