Select year and quarters between two date columns in multiple rows in a table

I have the following two tables

Table QuarterIssue

Table QuarterYear

The QuarterYear table is a master table which has all the years and quarters.

I have a custom requirement to write a query to get the quarters between two dates from these following two tables. I have to select all the years and quarters between Acq_Date and Dis_Date for all "ids" in the QuarterIssue table. Basically my result has to be,

This is what I have so far,

SELECT [YEAR], [Quarter], ([YEAR] + CAST([Quarter] AS DECIMAL)/10) A FROM QuarterYear QY 
WHERE ([YEAR] + CAST([Quarter] AS DECIMAL)/10) 
between 
(SELECT top 1 YEAR(Acq_Date) + CAST(DATEPART(qq, Acq_Date) AS DECIMAL)/10 as ACQ FROM 
QuarterIssue) 
and 
(SELECT top 1 YEAR(Dis_Date) + CAST(DATEPART(qq, Dis_Date) AS DECIMAL)/10 as DIS FROM 
QuarterIssue)

As you can see right now I'm able to get the desired result of one of the "id" at a time. Is there any way we can use join or subquery to return the results I'm expecting?

Here's a way to do it without the DISTINCT, if you're into that kind of thing (DISTINCT is often a very inefficient way - by means of a distinct sort - to hide the fact that a join returned too many rows because multiple rows matched).

Basically, we just convert each quarter from your master table into a start and end date, and then check for rows in the issue table that overlap (and I describe the overlap pattern here).

;WITH QuarterRange AS
(
  SELECT Year, Quarter, 
    RangeStart = DATEADD(MONTH, 3*(Quarter-1), 
                 DATEFROMPARTS(Year, 1, 1))
  FROM dbo.QuarterYear
)
SELECT Year, Quarter 
FROM QuarterRange AS qr
WHERE EXISTS
(
  SELECT 1 FROM dbo.QuarterIssue AS qi
    WHERE qi.Dis_Date >= qr.RangeStart
      AND qi.Acq_Date <  DATEADD(MONTH, 3, qr.RangeStart)
)
ORDER BY Year, Quarter;

• Working db<>fiddle example