The SQL statement in question does not return any records because it is joining on theEmailAddressfield, which is not present in the_BounceData View. The correct approach is to join using theSubscriberKey(or SubscriberID). Here is the corrected SQL statement:
SELECTs.EmailAddress, s.SubscriberKey, b.JobID, b.EventDate, b.SMTPBounceReasonFROM_Subscribers sJOIN_Bounce bONs.SubscriberKey=b.SubscriberKeyWHEREb.EventDate>DateAdd(DAY,-30, GETDATE()) This ensures that the join is based on theSubscriberKey, which is a common field in both data views.
References:
* Salesforce Marketing Cloud Data Views
* Query Activity Best Practices