Performing Table Merge Operation in MSSQL

[Paniked]

I am trying to create a car rental automation system. Right now, I will list the vehicles in the vehicles section using a DataGridView. There are tables for cars, brand, and model. I will match the brand ID in cars with the brand ID in the brand table to retrieve the brand name. This way, when listing the cars, the brand and model will be determined. I tried to use inner join for this but couldn't do it. How can I achieve this?