SQL Problems - Help!!!

From: <schnauzers_at_my-dejanews.com>
Date: Tue, 18 May 1999 15:16:28 GMT
Message-ID: <7hs08a$bvp$1@nnrp1.deja.com>

I am having problems with the following sql statement. I get a SQL command not properly ended error when it hits the first join. Any help will be greatly appreciated!

        SELECT mc.VENDOR.vendoi,mc.VENDOR.id as VendorID,mc.CONTACT.cntcoi AS ID,

        mc.CONTACT.aenm AS Name, mc.CONTACT.aenm AS LastName,

        mc.CONTACT.prefnm AS FirstName,
mc.CONTACT.jbttle,

        mc.CONTACTYPE.id AS ContactType,
mc.CONTACT.Language_id AS Language,

        mc.CONTACT.addr, mc.CONTACT.postcd AS
code, mc.REGIONLIST.regn AS Region,

        mc.COUNTRYLIST.cntry AS Country,
mc.CONTACT.phone, mc.CONTACT.fax

        FROM mc.VENDOR LEFT JOIN (((mc.CONTACT LEFT JOIN mc.CONTACTYPE ON

        mc.CONTACT.cntctyp_oi =
mc.CONTACTYPE.cntpoi)

        LEFT JOIN mc.REGIONLIST ON
mc.CONTACT.Region_oi = mc.REGIONLIST.regnoi)

	LEFT JOIN mc.COUNTRYLIST ON
mc.REGIONLIST.ctry_oi = mc.COUNTRYLIST.ctryoi)
	ON mc.VENDOR.cntctyp_oi =
mc.CONTACT.cntcoi
	WHERE ((mc.VENDOR.susp_oi) Is Null) AND

((mc.CONTACT.cntcoi) Is Not Null)

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 10:16:28 CDT