as an example I've a table hotel and resort has a number of images in a table HOTEL_IMAGE. lodge has 20 fields. accomplishing a join on HOTEL_IMAGE will create twenty fields for every resort image. will this query nonetheless be faster above the network ? Do you should Merge two tables and not using a common column? Learn how the CROSS JOIN along