Re: Query with inner join (Help!)

2003-08-15 Thread Steve Childs
Hi, You need to put the Join in the FROM section of the query, not the WHERE. That is to say, move this WHERE cust_id = 2 inner join Orders ON Customers.cust_id = Orders.cust_id to FROM Customers inner join Orders ON Customers.cust_id = Orders.cust_id You could acutally use this method

Re: Is this a Bug?

2003-08-14 Thread Steve Childs
) and was that in the max build only? Best Regards Steve Childs, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Steve Childs [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 9:35 AM Subject: Re: Is this a Bug? On Thu, Aug 14, 2003 at 09:05:50AM

Re: Is this a Bug?

2003-08-14 Thread Steve Childs
Cheers, that's it - I did look for any bug reports on this and didn't find any! - doh. Spot on - looks like an mySQL upgrade is in order! Best Regards Steve Childs, Webmaster www.mg-rover.org MG-ROVER.ORG - The ultimate, unofficial MG and Rover enthusiasts' website IMPORTANT INFORMATION: MG

Re: Is this a Bug?

2003-08-14 Thread Steve Childs
Secondly, they said they would turn off Raid in 4.0.13 - is that the case (didn't spot anything in the changelog) and was that in the max build only? Strangely, it seems to have been omitted from the changelog. erm, does that mean it was changed or not!? ;) Best Regards Steve Childs

Re: Is this a Bug?

2003-08-14 Thread Steve Childs
Hi Frank, I'm running Debian. Best Regards Steve Childs. - Original Message - From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED] To: Steve Childs [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 9:29 AM Subject: AW: Is this a Bug? Hi Steve, what LINUX-distibution do you use. I

Is this a Bug?

2003-08-14 Thread Steve Childs
. TIA Steve Childs. Experienced Newbie. ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]