iday, June 14, 2002 3:18 AM
Subject: RE: Help needed with JOIN on 3 tables
> This is what I found I will stop using Microsoft for development of
> mysql. I was running the queries locally on my Win2k machine using the
win32
> version of mysql. After screwing with it for several days I
Hi
SELECT b.* //all fields from builder
FROM
builder b //define tables and aliases
, builder_category_link l
, category c
WHERE
(b.builderID = l.builderID) //linking builder to link table
AND (l.categoryID = c.categoryID)
again.
-Original Message-
From: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:28 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Help needed with JOIN on 3 tables
Hiho hiho!
bob wrote:
>Hi,
>
>I'm very new to mysql and I'm having a pro
Hiho hiho!
bob wrote:
>Hi,
>
>I'm very new to mysql and I'm having a problem getting my joins to work. I
>have 3 tables:
>
>builder
>category
>builder_category_link
>
>The builder table has a an id field and then several other fields (name,
>address etc)
>The category table has an id field and t
