mysql - 我不知道出了什么问题？来人帮帮我

Question

SELECT
person.CustomerID as CustomerID,
address.Street as Street,

(
SELECT FROM Company comp
WHERE comp.Id = person.ID
AND entry_key = '_custComment' ) comp
,(SELECT FROM company comp
WHERE company.ID = person.ID
AND entry_key = '_otherInfo') other
Address addr, 
Person person
WHERE person.cid = custbasicinfo.cid
AND person.cid = addr.cid

标签： mysql

Answer 1

语法更正确，可能是垃圾..

SELECT
person.CustomerID as CustomerID,
address.Street as Street,
(SELECT a FROM Company comp WHERE comp.Id = person.ID AND entry_key = '_custComment' ) comp,
(SELECT a FROM company comp WHERE company.ID = person.ID AND entry_key = '_otherInfo') other
from Address addr, Person person
WHERE person.cid = custbasicinfo.cid AND person.cid = addr.cid