Page 259 - BiDiB und iTrain

SELECT NEO_Accessories.F1, NEO_Accessories.F2, 'NEO' AS Modul
FROM NEO_Accessories
WHERE (((NEO_Accessories.F1) Like "A##") AND (Not (NEO_Accessories.F2) =''));
UNION
SELECT OneControl_Accessories.F1, OneControl_Accessories.F2, 'OneControl' AS
Modul
FROM OneControl_Accessories
WHERE (((OneControl_Accessories.F1) Like "A##") AND (Not
(OneControl_Accessories.F2) =''));
UNION SELECT ST4_Accessories.F1, ST4_Accessories.F2, 'ST4' AS Modul
FROM ST4_Accessories
WHERE (((ST4_Accessories.F1) Like "A##") AND (Not (ST4_Accessories.F2) =''));

Hier haben wir die UNION Verbindung – es werden die Abfragen zu IO24-
LightControl-NEO-OneControl_ST4 zusammengefasst. Weiterhin ist hier eine
NOT-Abfrage als Beispiel da – Also Nicht Leer Not =‘‘ oder <>‘‘ Leer. Beides kann
man verwenden.