title: Is a Join Faster than two queries
body: <p>I know this question has been asked before, 
  <a href="https://stackoverflow.com/questions/4758712/which-of-the-following-sql-queries-would-be-faster-a-join-on-two-tables-or-succe">example</a>, and I do agree that one query with a join is faster than performing another query for each record returned by the firs query.</p>
  
  <p>However, since with a join you tend to generate redundant field will this slow the network ?</p>
  
  <p>Let's say I have a table hotel and HOTEL has a number of images in a table HOTEL_IMAGE. HOTEL has 20 fields. performing a join on HOTEL_IMAGE will produce 20 fields for each hotel image. will this query still be faster over the network ?</p>