jjzjj

RelatedColumn

全部标签

mysql - mySQL 中的子查询结构以获得最佳性能

在MSSQLServer中,此查询正常运行:SELECTcolumn1,(SELECTRelatedColumn1FROMtbl_relatedWHERErecord_id=a1.record_id)ASpseudocolumn1,(SELECTRelatedColumn2FROMtbl_relatedWHERErecord_id=a1.record_id)ASpseudocolumn2,(SELECTRelatedColumn3FROMtbl_relatedWHERErecord_id=a1.record_id)ASpseudocolumn3,(SELECTRelatedColumn