On 7/12/07, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
I think that will give me one record for every price that is not Yen, so if a product has a price in USD and a price in GBP it will show up twice.
That would happen if you removed the 'USD' condition from the first JOIN. Like I said, I'm not certain what results you're trying to get, but the LEFT JOIN technique is probably your best bet. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]