My first questions is can I have query criteria like this if it is to much and just have criteria



project

equals

whatever
whatever
to the maximum

then.............................................. ..............................

project

equals a different set

of whatever
whatever
whatever
whatever


Will the criteria look at both of the columns of projects



The second question is that i have three tables two tables are joined and third table is not when i added column from the table that is not joined i made the criteria unique only will the third table that is not joined show the right information that it connected to with the other two tables that are connected