I have a query that works fine in mssql and have to port it to access. Trust me
I don't want to use access it's not an option for the client to switch to a
real db. So I'm stuck trying to port this.
When I run it on the access db I get the following error:
"Syntax error (missing operator) in query expression..."
Any help would be grand. Thanks in advance.
Here's my query.
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:3157
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
