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
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