It looks like I was a little hasty in posting to the forum. After some messing
around I got it to work. For some reason it seems access needs parentheses.
Here's the query that works.
SELECT lc.vendor_new_ID, lc.contact_email, lc.contact_lname,
lc.contact_fname, b.new_bid_ID, b.ReferenceNumber, b.Title,
b.Description, jb.cccode_ID, bid_ID, jv.cccategory_ID, jv.vendor_ID
FROM ((junction_bid_ccc jb
LEFT
JOIN junction_vendor_ccc jv
ON jb.cccode_ID = jv.cccategory_ID)
LEFT
JOIN lookup_contact lc
ON lc.vendor_new_ID = jv.vendor_ID)
LEFT
JOIN Bid b
ON b.new_bid_ID = jb.bid_ID
WHERE jb.bid_ID = 446
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3158
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
