Querying Compatibility and Storage Locations in Database Records

Jan 01, 2026

10 likes | 125 Vues

This document outlines a structured query for database records involving compatibility checks in the context of versions V1 and V2. It examines how to identify records in the "Verträglichkeit" (compatibility) table where specific conditions are not met. By filtering based on entry numbers (ANr) and storage locations (Lagerort), the query aims to find entries in V1 that do not have corresponding entries in V2 matching both the ANr and storage location number (LoNr). This approach assists in ensuring data integrity and proper record management.

ekram

Télécharger la présentation

Querying Compatibility and Storage Locations in Database Records

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

Division (2) V1 in Verträglichkeit, V2 in Verträglichkeit, LO in Lagerort;V1.ANr where  LO ($ V2 (V2.ANr = V1.ANr V2.LoNr = LO.LoNr)); V1 in Verträglichkeit, V2 in Verträglichkeit, LO in Lagerort;V1.ANr where " LO ($ V2 (V2.ANr = V1.ANr V2.LoNr = LO.LoNr)); select ANr from Verträglichkeit V1 wherenot exists ( select from Lagerort Lo where not exists ( select from Verträglichkeit V2 where V2.ANr = V1.ANr and V2.LoNr = Lo.LoNr));