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 -

python - ValueError: could not convert string to float -

php - Laravel Get all child node count with condition -