gistfile1.txt

SELECT Status, Title, [Comes with Title], Collection, Location, [Box Color]
FROM (
    SELECT Status, Title, [Comes with Title], Collection, Location, [Box Color], Format
    FROM [Order Table 2010/2011]
    WHERE Status<>'ceased' AND Status<>'not renewed' AND Format<>'online'
    UNION ALL
        SELECT Status, Title, [Comes with Title], Collection, Location, [Box Color], Format
        FROM [Free Magazines]
    UNION ALL
        SELECT Status, Title, [Comes with Title], Collection, Location, [Box Color], Format
        FROM [Alternate names]
)
ORDER BY Title, Collection;