您好，我有下图所示的表结构我正在尝试在mysql中编写查询以获取来自customer表或vendortable的name,address,mono取决于来自transportsticker表的whoseid值我试过SELECTtransportsticker.*,AA.name,AA.address,AA.monoFROMtransportstickerINNERJOIN(casewhen(transportsticker.whoseid='vendor')then(vendortable)else(customertable)end)AAONAA.id=transportsticke