this is the error...

A Database Error Occurred

Error Number: 23000/1052

Column 'id' in field list is ambiguous

SELECT id FROM tbl_vendor INNER JOIN tbl_item ON id=vendor_id WHERE shop = 'BVC'

Filename: C:/xampp/htdocs/parts/system/database/DB_driver.php

Line Number: 691

$shop= $this->input->post('vendor');
                      $this->db->select('id');
                      $this->db->from('tbl_vendor');
                      $this->db->join('tbl_item', 'vendor_id=id', 'inner');
                      $this->db->where('shop', $shop);
                      $query=$this->db->get();