On Thu, 3 Jun 2004 15:22:36 -0500 Josh Trutwin <[EMAIL PROTECTED]> wrote:
> Or in preferable INNER JOIN syntax which makes it easier to forget a > JOIN condition: Oops - I meant "harder to forget" not "easier to forget". Doh. > > SELECT c.cst_SiteID, c.cst_IDC, a.asset_ID, o.offer_ID, > o.offer_Name FROM customers c > INNER JOIN assets a ON c.cst_SiteID = a.asset_SiteID > INNER JOIN offers o ON c.cst_Offer = o.offer_ID > WHERE cst_Name LIKE 'z%'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
