Hi John,

Thanks for taking the time to help me its all working now.

Thw query I have is below

select CarNo, Reg_Plate, LeaseYesNo, Car_Type, Car_Colour, CarMake, Keyword AS CarColour
from dbo.VehicleDetails
join dbo.KeywordsColour
on dbo.KeywordsColour.KeywordNo =dbo.VehicleDetails.Car_Colour
join...

Hi John,

Thank you for taking the time to get back to me I had got as far as the below

select CarNo, Reg_Plate,...