Re: [PHP-WIN] SQL syntax question

2005-01-10 Thread Randy Clamons
f I can. Randy Clamons Systems Programming Astro-auction.com > Original Message > From: "Anne Shroeder" <[EMAIL PROTECTED]> > To: "PHP Windows Mailing List" > Date: Mon, Jan-10-2005 9:18 AM > Subject: [PHP-WIN] SQL syntax question &

[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