Hello, need a bit of help on any SQL string. I've set up the following tables:
tblOfferings
offeringID, offeringTitle, offeringLocation, dateofProd, duration
tblTechnologies
technologyID
technology
tblTechnologyLookup
offeringID
technologyID
I'm trying to set up a query to get the offering title for a particular technology, in this case technology181
HEre is my SQL String:
SELECT tblOfferings.offeringTitle FROM tblOfferings, tblTechnologyLookup WHERE tblOfferings.offeringID = tblTechnologyLookup.offeringID AND tblTechnologyLookup.technologyID = 181;
The error I get is
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I've verified the field names and it doesn't seem to be the issue. I'm using Access with an ASP front end. Thanks for everyone for your help.
Topic Options
Post Options
Thanks(0)
