PnzrDrgoon Posted June 16, 2010 Share Posted June 16, 2010 Is it possible to do the following? SELECT `a`.`f1`,`a`.`f2`,`b`.`f3`, `s`.`f4` FROM `a` CASE `a`.`f1` WHEN 1 THEN INNER JOIN `b` ON `a`.`fx`=`b`.`fz` ELSE INNER JOIN `c` AS `s` ON `a`.`fx`=`s`.`fz` Link to comment https://forums.phpfreaks.com/topic/204966-is-join-by-case-possible/ Share on other sites More sharing options...
ignace Posted June 16, 2010 Share Posted June 16, 2010 No. But following the logic, you are after a LEFT OUT JOIN Link to comment https://forums.phpfreaks.com/topic/204966-is-join-by-case-possible/#findComment-1073063 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.