I am querying a DE and trying to left join _Subscribers on SubscriberKey. I am getting results back from the left side, Master_DE, but nothing is coming back for the Status column. I am wondering if there is something wrong with my SQL? m.SubscriberKey is a text(100) DE field. I also know there should be data coming back because I have verified the matching rows exist.
SELECT m.personid, m.[join_date], s.status FROM [master_de] m LEFT JOIN _Subscribers s ON m.SubscriberKey = s.SubscriberKey WHERE [join_date] > Dateadd(d, -7, Getdate()) AND [join_date] < Dateadd(d, Datediff(dd, 0, Getdate()), 0)