[PHP-WIN] SQL syntax question

2005-01-10 Thread Anne Shroeder
Not sure if this is the right list to post this to or not -- I'm having a problem with getting a MySQL query to work. I need to do two things: (1) multiply the value of x*y (and thus have to do a group by) from fields in one table, AND (2) do a lookup of the name value in another table for a fore

Re: [PHP-WIN] SQL syntax question

2005-01-10 Thread Randy Clamons
Anne, Actually, you can group by a foreign table. When you say "it breaks", what exactly do you mean? What results do you get? What results did you expect? What is your MySql version? This question should probably be submitted to one of the MySql lists, but I'll help you if I can. Randy Cl