| Yaslaw.Info > MS Access |
Impressum  ∞ |
MS Access
Differenzen zweier Tabellen
SELECT T1.Field1, T2.Field1
FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1
WHERE T2.Field1 IS NULL;
FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1
WHERE T2.Field1 IS NULL;
Datumsformat im Query
#mm/dd/yyyy#
SELECT *
FROM myTable
WHERE myDate = #03/11/2010#
FROM myTable
WHERE myDate = #03/11/2010#
Zeileumbruch im Query
Chr(13) & Chr(10)
UPDATE logtable
SET log = "new String" Chr(13) & Chr(10) & log;
SET log = "new String" Chr(13) & Chr(10) & log;
