Re: select using 2 left joins

2002-09-02 Thread W. Enserink
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

Re: select using 2 left joins

2002-09-02 Thread Jed Verity
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

select using 2 left joins

2002-09-02 Thread Wilbert Enserink
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