join ตาราง 2 ตาราง แล้วรับค่า เขียน WHERE รับค่า $_GET ยังไง

owner='$_GET[select]'

owner='".$_GET[select]."'

$sql ="SELECT * FROM tb_company INNER JOIN tb_asset ON  tb_company.comp_id = tb_asset.as_id  WHERE owner='".$_GET[select]."' ";
$sql .="AND year='".$_GET[year_as]."' AND company='".$_GET[company]."' ";

Error Query = SELECT tb_asset.owner FROM tb_company INNER JOIN tb_asset ON tb_company.company_name Operater tb_asset.owner WHERE owner='TOS' AND year='2555' AND company='[TOS] Toscana Valley Co.,Ltd'

$sql = "SELECT tb_asset.owner FROM tb_company INNER JOIN tb_asset ON tb_company.company_name = tb_asset.owner WHERE owner='TOS' AND year='2555' AND company='[TOS] Toscana Valley Co.,Ltd' ";

Syntax
SELECT * FROM table1 INNER JOIN table2 ON table1.primary_key = table2.foreign_key ;

SELECT * FROM tb_company INNER JOIN tb_asset ON  tb_company.comp_id = tb_asset.as_id  WHERE owner='".$_GET[select]."'


SELECT * FROM tb_company INNER JOIN tb_asset ON tb_company.comp_id= tb_asset.as_id WHERE owner='TOS' AND year='2555' AND company='[TOS] Toscana Valley Co.,Ltd' 

SELECT tb_company.*, tb_asset.* FROM tb_company INNER JOIN tb_asset ON tb_company.comp_id= tb_asset.as_id WHERE owner='TOS' AND year='2555' AND company='[TOS] Toscana Valley Co.,Ltd' 

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0007 sec)