您将不得不在
IF那里重复通话。例如:
SELECt name, IF(apple = 'brown', color1, color2) AS ripenessFROM apples JOIN apple_type ON apple_type.color = IF(apple = 'brown', color1, color2)

您将不得不在
IF那里重复通话。例如:
SELECt name, IF(apple = 'brown', color1, color2) AS ripenessFROM apples JOIN apple_type ON apple_type.color = IF(apple = 'brown', color1, color2)