SQL Question

I have two GL tables... GLMAST and GLDETL.

GLMAST stores period totals for a GL account for a given year. Account, Year, Beginning Balance, Period 1, Period 2, etc.
GLDETL contains the individual GL credit/debit transactions.

I'm trying to do a report that shows beginning balance, credits, debits, and ending balance for a given account and year/period.
The problem is this:

1. The GLMAST doesn't contain a record for an account & year where every period total is $0.00.
2. The GLDETL may not have any transactions for a given account/year/period, but may still have a beginning balance in GLMAST

My output needs to have a row if data exists in EITHER table for a give account, year and period.
I'm not sure how to do that using an SQL statement or view. Looking for ideas.

Thanks,
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>