going in circles with a basic query definition.
In a query I would like to show on which dates a client is booked and on which days the client is still available.
There is something wrong in my query because it does not display 1/10 for Black , likewise if the filter is set to Smith then 7/10 does not show up.
Code: Select all
SELECT "tblCalendar"."date", "tblBooking"."client", "tblBooking"."bdate", "tblFilter"."client"
FROM { oj "tblBooking" RIGHT OUTER JOIN "tblCalendar" ON "tblBooking"."bdate" = "tblCalendar"."date" }, "tblFilter"
WHERE ( "tblBooking"."client" = "tblFilter"."client" OR "tblBooking"."bdate" IS NULL )
db attached