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` Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.