FireBird Subqueries

SELECT A.Col1, A.Col2 FROM
(SELECT Col1, Col2 FROM Table1) AS A;

SELECT A.Artist, A.Title FROM
(SELECT Albums.Artist, Albums.Title FROM Albums) AS A;

SELECT A.Title FROM
(SELECT ...complex query with multiple joins and one union...) AS A
GROUP BY A.Title;

CREATE VIEW v1 AS SELECT ...complex query with multiple joins and one union...;

SELECT Title FROM
v1
GROUP BY Title;

SELECT Albums.* FROM Tokenize('Albums Title') Tokenize
       INNER JOIN Tokens ON Tokenize.Token = Tokens.Token
       INNER JOIN Index_Albums ON Tokens.TokenID = Index_Albums.TokenID
       INNER JOIN Albums ON Index_Albums.AlbumID = Albums.AlbumID

SELECT Albums.Title, Albums.TrackCount, COUNT(*) FROM Tracks
       INNER JOIN Albums ON Tracks.AlbumID = Albums.AlbumID
WHERE
     Albums.AlbumID IN (
         SELECT AlbumID FROM Tokens
             INNER JOIN Index_Albums ON Tokens.TokenID = Index_Albums.TokenID
             WHERE Token = 'Aphex' OR Token = 'Twin'
     ) OR
     Tracks.TrackID IN (
         SELECT TrackID FROM Tokens
             INNER JOIN Index_Tracks ON Tokens.TokenID = Index_Tracks.TokenID
             WHERE Token = 'Aphex' OR Token = 'Twin'
     ) AND
     (Albums.Artist CONTAINING 'Aphex Twin' OR
     Tracks.Artist CONTAINING 'Aphex Twin')
GROUP BY Albums.Title, Albums.TrackCount;

SELECT * FROM Tokenize('Apehx Twin') Tokenize
      INNER JOIN Tokens ON Tokenize.Token = Tokens.Token
      INNER JOIN Index_Tracks ON Tokens.TokenID = Index_Tracks.TokenID
      INNER JOIN Tracks ON Index_Tracks.TrackID = Tracks.TrackID
      INNER JOIN Albums ON Tracks.AlbumID = Albums.AlbumID

SELECT
      Albums.AlbumID,...
FROM Tokenize('Aphex Twin') Tokenize
       INNER JOIN Tokens ON Tokenize.Token = Tokens.Token
       INNER JOIN Index_Tracks ON Tokens.TokenID = Index_Tracks.TokenID
       INNER JOIN Tracks ON Index_Tracks.TrackID = Tracks.TrackID
       INNER JOIN Albums ON Tracks.AlbumID = Albums.AlbumID
       LEFT OUTER JOIN Discs ON Tracks.DiscID = Discs.DiscID
WHERE
       Albums.Artist CONTAINING 'Aphex Twin' OR
       Tracks.Artist CONTAINING 'Aphex Twin'
GROUP BY
      Albums.AlbumID, ...
UNION
SELECT
      Albums.AlbumID,...
      FROM Tokenize('Aphex Twin') Tokenize
       INNER JOIN Tokens ON Tokenize.Token = Tokens.Token
       INNER JOIN Index_Albums ON Tokens.TokenID = Index_Albums.TokenID
       INNER JOIN Albums ON Index_Albums.AlbumID = Albums.AlbumID
       INNER JOIN Tracks ON Index_Albums.AlbumID = Tracks.AlbumID
       LEFT OUTER JOIN Discs ON Tracks.DiscID = Discs.DiscID
WHERE
       Albums.Artist CONTAINING 'Aphex Twin' OR
       Tracks.Artist CONTAINING 'Aphex Twin'
GROUP BY
      Albums.AlbumID, ...;