Hi guys,

I need little help.

I have two tables.
Table1: bsi_car_master
Columns: car_id | car_vendor_id | car_model

note: car_vendor_id column is the id of Table2

Table2: bsi_car_vendor
Columns: id | vendor_title

I just want to combine vendor_title of Table2 and car_model of Table1
How to properly SELECT this?

Thank you very much in advance.