I'm obviously doing something wrong with my union query b/c I'm getting more records than I should.
Not sure how I can write a Union query where I can get the Facility ID and the month where they are equal in each table. This is what I wrote, which gave me duplicate facility numbers.
Select `Month Year Formatted`, `Facility ID` FROM 1a_Construction_Month_Format WHERE `TotalNBV`<>"0" UNION Select `Booking Date`, `Facility ID` FROM 1b_Construction_BookingDt_Format
ORDER BY `Facility ID`;
I basically only want the facility Id and the date where the Month Year Formatted and the Booking date are equal.
Instead, I'm getting the date and facility id where TotalNBV<>0.