I have 3 tables like this:
Category
| CategoryID | CategoryName |
|---|---|
| 11 | Beer |
| 12 | Wine |
MenuAvailable
| TimingID | DayFrom | DayTo |
|---|---|---|
| 6 | 1 | 5 |
| 7 | 5 | 6 |
MultipleMenuAvailable
| CategoryID | TimingID |
|---|---|
| 11 | 6 |
Expected result
| CategoryID | CategoryName | TimingID | DayFrom | DayTo |
|---|---|---|---|---|
| 11 | Beer | 6 | 1 | 5 |
| 12 | Wine | null | null | null |
| null | null | 7 | 5 | 6 |
What I've tried:
select c.CategoryID, c.CategoryName,
m.TimingID, m.DayFrom, m.DayTo
from category as c
left join multiplemenuavailability as ma on c.CategoryID = ma.CategoryID
left join menuavailability as m on m.TimingID = ma.TimingID;
Any help is appreciated, thanks in advance!
