Timeline for MySQL getting result using 3 Tables and case statements
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15, 2013 at 5:22 | comment | added | Aditya | oop's. Consider the logic & try. | |
| Nov 14, 2013 at 15:21 | comment | added | drunken_monkey |
Nope, does not work. if you do select from person left join person2 ... then you only get users that are in person. If a phone number is not in person, it will not show up and the case does not state that there is a leading table that contains all phone numbers from which we can then left join.
|
|
| Nov 14, 2013 at 14:17 | comment | added | JamesRyan | you don't need outer joins. left join all 3 tables to select 1234 as phno then check for nulls | |
| Nov 14, 2013 at 14:13 | comment | added | Karthik | @Aditya as drunken_monkey said MySQL does not support full outer joins. Also one of my friend is saying that it can be achieved by using case statement alone. | |
| Nov 14, 2013 at 13:19 | comment | added | drunken_monkey | mysql does not support full outer joins | |
| Nov 14, 2013 at 7:30 | history | answered | Aditya | CC BY-SA 3.0 |