SELECT        app_id, stock_taking_date,
                             (SELECT        app_description
                               FROM            Apparaat
                               WHERE        (app_id = Verkoop.app_id)) AS AppNaam,
                             (SELECT        cat_description
                               FROM            Categorie
                               WHERE        (cat_code =
                                                             (SELECT        app_cat_code
                                                               FROM            Apparaat AS Apparaat_2
                                                               WHERE        (app_id = Verkoop.app_id)))) AS CatNaam,
                             (SELECT        merk_full_name
                               FROM            Merk
                               WHERE        (merk_id =
                                                             (SELECT        merk_id
                                                               FROM            Apparaat AS Apparaat_1
                                                               WHERE        (app_id = Verkoop.app_id)))) AS MerkNaam, quantity
FROM            Verkoop