Doing a simple left join of two tables, I do this all the time, but today it's turning the joining table's data null.
SELECT ThirdTier.*, ThirdOrg.Type as Type
Left JOIN ThirdOrg
The data from ThirdTier is fine, the data from ThirdOrg becomes all <NULL>.
If I switch ThirdTier and ThirdOrg, the opposite happens. ThirdOrg data is fine, ThirdTier data is all null. WTH?! Please help.