Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Accurate Results from Query

Author  Topic  cfrishe Starting Member 1 Post Posted - 2001-04-18 : 10:43:33 When I try to do the following query, one of the tables always superseeds the other with the results. (ie. in this query the results seem as if the "Table.Company" condition was completly ignored and seems like it returns results based on the "Table2.Other" only) Select Table1.*, Table2.* From Table1 Inner Join Table2 on Table1.ID = Table2.ID WHERE Table1.Company Like '%graphic%' And Table2.Other Like '%%flowers%% Using Access, how can I change my SQL statement to search multiple fields in multiple tables (such as the example) and get accurate results?