sql - Access query returns no results when criterion added -


i running following query in access 2010

select      [table1].[field4], table2.id, table2.["fielld1"],     table2.["field3"], table2.["field2"]      table2  inner join      [table1] on table2.id = [table1].[field4]      table2.["field3"]="xx" 

it runs without clause, returns no results when clause added. know records exist. ideas?


Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -