ACCESS SQL: Multiple Inner join and LIKE Clause?
-
"SELECT* FROM ((Shoes S INNER JOIN Type T ON S.tTypeCode = T.tTypeCode) INNER JOIN Brand B ON S.bBrandCode = B.bBrandCode) WHERE ((S.sSize LIKE '%" & keyword & "%') OR (S.sDecritpion LIKE '%" & keyword & "%') OR (B.bBrandName LIKE '%" & keyword & "%') OR (T.tTypeName LIKE '%" & keyword & "%')) " For some reason error : "No value given for one or more required parameters" in VB.NET When I try it in access ask me for data for the Collumns names :S
-
Answer:
Well one potential problem I'm noticing is this part: (Shoes S INNER JOIN Type T ON S.tTypeCode=T.tTypeCode) INNER JOIN (Brand B ON S.bBrandCode=B.bBrandCode) Brand B ON S.bBrandCode... this line won't work as far as I know (I obviously can't test it right now) because 'S' was defined in a different scope. It doesn't know what S is. Your query seems overly complex. What data are you trying to get? Perhaps we can simply the query for you.
Yahoo! Answers Visit the source
Related Q & A:
- How to add primary key from multiple table as a foreign key in a table in sql server 2008?Best solution by stackoverflow.com
- What is the performance of INNER JOIN vs WHERE?Best solution by Stack Overflow
- How to do SQL inner queries through SQLAlchemy?Best solution by Stack Overflow
- How to write delete query with inner join?Best solution by codeproject.com
- How to write SQL statement with dynamic where clause?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.