Page 259 - BiDiB und iTrain
P. 259

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.
   254   255   256   257   258   259   260   261   262   263   264