SELECT
tourism_category.ID, 
tourism_category.Full_Name, 
tourism_category.Name, 
tourism_category.Geo_County, 
tourism_category.Geo_Region, 
tourism_links.Geo_County, 
tourism_links.Geo_Region 
FROM 
tourism_links, 
tourism_category 
WHERE 
tourism_category.Geo_County = tourism_links.Geo_County, 
tourism_category.Geo_Type = tourism_links.Geo_Region 
AND tourism_links.CategoryType = tourism_category.Geo_Type2