postgres数据库查询语法错误,明明没问题
//第一次查询提示语法错误
beap=#
beap=# select a.beap_cutomer_id, a.unit_code from beap_customers as a, customer_status as b where a.beap_cutomer_id=b.customer_id and b.online_status=1 and a.unit_code like '4401%';
错误: 语法错误 在 "select" 或附近的
第1行select a.beap_cutomer_id, a.unit_code from beap_customers ...
^
//重写一遍select单词
beap=#
beap=# select a.beap_cutomer_id, a.unit_code from beap_customers as a, customer_status as b where a.beap_cutomer_id=b.customer_id and b.online_status=1 and a.unit_code like '4401%';
beap_cutomer_id | unit_code
-----------------+----------------
2013250 | 44011321102813
2004863 | 44010421104480
2005381 | 44010521103539
2004716 | 44010421104250
2005030 | 44011121142282
801040036 | 44010421112769
801140016 | 44011421113002