单项选择题已知:有lanuge和conpamyporject两张表,两表的关系图如下,conpamyporject表的fkid是外键,引用的是lanuge表的主键id字段,以下选项中属于左连接查询的sql语句是()。
A.SELECT *FROM lanuge JOIN conpamyporject ON lanuge.id=conpamyporject.fkid
B.SELECT *FROM lanuge LEFT JOIN conpamyporject ON lanuge.id=conpamyporject.fkid
C.SELECT *FROM lanuge LEFT JOIN conpamyporject conpamyporject.id =lanuge.id
D.SELECT *FROM lanuge LEFT JOIN conpamyporject ON lanuge.id=lanuge.id