SELECT two tables? Basic for Gurus

Databases
1

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.

2

This is what I tried so far,


$query = "SELECT bsi_car_vendor.vendor_title, bsi_car_master.car_model".
		 "FROM bsi_car_vendor, bsi_car_master ".
		 "WHERE bsi_car_vendor.id = bsi_car_master.car_vendor_id";

I’m not sure if It is correct.
Can someone inspect my work please.
Thanks in advance.

3

Okay this select works,


$sql = "SELECT bsi_car_vendor.vendor_title, bsi_car_master.car_model FROM bsi_car_vendor, bsi_car_master WHERE bsi_car_vendor.id = bsi_car_master.car_vendor_id";

My question, My answer lol
Thanks to me.