> -----Original Message----- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 17, 2003 8:12 AM > To: [EMAIL PROTECTED] > Subject: RE: Issues with count(), aliases, and LEFT JOINS > > Try changing it to this: > > ... > -> COUNT(DISTINCT switch_connect1.switch_id) AS left_port_count, > -> COUNT(DISTINCT switch_connect2.switch2_id) AS > right_port_count, > ... > > I would suggest, if that suggestion fails, that you > experiment with just > switch_connect.switch_port and switch_connect.switch2_port . > Problems are > much easier to define and solve if you simplify them down to > the basics. If > you're able to do what you want with those values Then you can add the > complexity of JOINing to other tables and you'll know when it > 'should work' > and not. > > Chris >
That fixed it, thanks bunches. There any explaination as to why that made it work? Brandon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
