nk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 02, 2002 6:38 PM
Subject: Re: select using 2 left joins
> I'm a little surprised that MySQL isn't giving you an error on the
ambiguity
> of manufacturersID=12. What happens if you specify
> tableName.m
I'm a little surprised that MySQL isn't giving you an error on the ambiguity
of manufacturersID=12. What happens if you specify
tableName.manufacturersID=12?
HTH,
Jed
On the threshold of genius, Wilbert Enserink wrote:
> Hi all,
>
>
> I'm having troubles with a good selection statement in my
Hi all,
I'm having troubles with a good selection statement in my query.
I have three tables:
tableAds, tableProducts and tableManufacturer. They all have unique ID's
defined.
In the tableProducts there is a column named manufacturerID. So I know which
product was made by which manufacturer.
I