Hi I have two tables :1.Regions and 2.subregions First I need to select region Id and region name from regions table , subregion id And subregion name from subregions then I have to match subregion name to region name. please help thanks