Timeline for Return all rows from table1 and corresponding rows from table2 even if null
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 10, 2017 at 18:20 | vote | accept | Marcelo Fialho | ||
| Jan 10, 2017 at 18:03 | answer | added | ypercubeᵀᴹ | timeline score: 1 | |
| Jan 10, 2017 at 18:00 | comment | added | Laughing Vergil |
Although this could be another place to use the ubiquitous (and very useful) tally table construct, there is an easier way to do this in the WHERE clause, e.g. WHERE ISNULL(tb2.year, 2017) = 2017 AND ISNULL(tb2.month, 1) = 1
|
|
| Jan 10, 2017 at 17:59 | review | First posts | |||
| Jan 10, 2017 at 19:47 | |||||
| Jan 10, 2017 at 17:54 | history | asked | Marcelo Fialho | CC BY-SA 3.0 |