title: Do SQL from non-empty table in MS Access
body: <p>Suppose you have two tables in MS Access, Table1 and Table2 with the same structure (i.e. the same columns). I would like to write a query where if Table1 is empty then I have to get the data from Table2 else get the data from Table1.</p>
  
  <p>I am not sure how to use IIF statements in such a way. </p>