Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
SELECT A.A, IIf([b] Is Null,"-",[b]) AS C FROM A LEFT JOIN B ON A.A = B.B ORDER BY A.A
UNION
SELECT IIf([a] Is Null,"-",[a]) AS C, B.B FROM B LEFT JOIN A ON B.B = A.A
SELECT A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.H,
IIf([B.A] Is Null,"-",[B.A]) AS K,
IIf([B.B] Is Null,"-",[B.B]) AS L,
IIf([B.C] Is Null,"-",[B.C]) AS M,
IIf([B.D] Is Null,"-",[B.D]) AS N,
IIf([B.E] Is Null,"-",[B.E]) AS P,
IIf([B.F] Is Null,"-",[B.F]) AS R,
IIf([B.G] Is Null,"-",[B.G]) AS S,
IIf([B.H] Is Null,"-",[B.H]) AS T
FROM A LEFT JOIN B ON A.A = B.A AND A.B = B.B AND A.C = B.C AND A.D = B.D AND A.E = B.E AND A.F = B.F AND A.G = B.G AND A.H = B.H ORDER BY A.A
UNION SELECT
IIf([A.A] Is Null,"-",[A.A]) AS K,
IIf([A.B] Is Null,"-",[A.B]) AS L,
IIf([A.C] Is Null,"-",[A.C]) AS M,
IIf([A.D] Is Null,"-",[A.D]) AS N,
IIf([A.E] Is Null,"-",[A.E]) AS P,
IIf([A.F] Is Null,"-",[A.F]) AS R,
IIf([A.G] Is Null,"-",[A.G]) AS S,
IIf([A.H] Is Null,"-",[A.H]) AS T,
B.A, B.B, B.C, B.D, B.E, B.F, B.G, B.H FROM B LEFT JOIN A ON B.A = A.A AND B.B = A.B AND B.C = A.C AND B.D = A.D AND B.E = A.E AND B.F = A.F AND B.G = A.G AND B.H = A.H;
SELECT A.A,A.B,A.C, IIf([B.A] Is Null,"-",[B.A]) AS K, IIf([B.B] Is Null,"-",[B.B]) AS L, IIf([B.C] Is Null,"-",[B.C]) AS M
FROM A LEFT JOIN B ON A.A = B.A AND A.B = B.B AND A.C = B.C
WHERE (
([A].[A] Not In (SELECT A.A FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (A.A) Is Null)
AND ([A].[B] Not In (SELECT A.B FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (A.B) Is Null)
AND ([A].[C] Not In (SELECT A.C FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (A.C) Is Null)
)
ORDER BY A.A
UNION
SELECT IIf([A.A] Is Null,"-",[A.A]) AS K, IIf([A.B] Is Null,"-",[A.B]) AS L, IIf([A.C] Is Null,"-",[A.C]) AS M, B.A, B.B, B.C
FROM B LEFT JOIN A ON B.A = A.A AND B.B = A.B AND B.C = A.C
WHERE (
([B].[A] Not In (SELECT B.A FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (B.A) Is Null)
AND ([B].[B] Not In (SELECT B.B FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (B.B) Is Null)
AND ([B].[C] Not In (SELECT B.C FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C)) Or (B.C) Is Null)
)
SELECT A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.H,
IIf([B.A] Is Null,"-",[B.A]) AS K,
IIf([B.B] Is Null,"-",[B.B]) AS L,
IIf([B.C] Is Null,"-",[B.C]) AS M,
IIf([B.D] Is Null,"-",[B.D]) AS N,
IIf([B.E] Is Null,"-",[B.E]) AS P,
IIf([B.F] Is Null,"-",[B.F]) AS R,
IIf([B.G] Is Null,"-",[B.G]) AS S,
IIf([B.H] Is Null,"-",[B.H]) AS T
FROM A LEFT JOIN B ON A.A = B.A AND A.B = B.B AND A.C = B.C AND A.D = B.D AND A.E = B.E AND A.F = B.F AND A.G = B.G AND A.H = B.H
WHERE (
([A].[A] Not In (SELECT A.A FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.A) Is Null)
AND ([A].[B] Not In (SELECT A.B FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.B) Is Null)
AND ([A].[C] Not In (SELECT A.C FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.C) Is Null)
AND ([A].[D] Not In (SELECT A.D FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.D) Is Null)
AND ([A].[E] Not In (SELECT A.E FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.E) Is Null)
AND ([A].[F] Not In (SELECT A.F FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.F) Is Null)
AND ([A].[G] Not In (SELECT A.G FROM A INNER JOIN B ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (A.G) Is Null)
)
ORDER BY A.A
UNION SELECT
IIf([A.A] Is Null,"-",[A.A]) AS K,
IIf([A.B] Is Null,"-",[A.B]) AS L,
IIf([A.C] Is Null,"-",[A.C]) AS M,
IIf([A.D] Is Null,"-",[A.D]) AS N,
IIf([A.E] Is Null,"-",[A.E]) AS P,
IIf([A.F] Is Null,"-",[A.F]) AS R,
IIf([A.G] Is Null,"-",[A.G]) AS S,
IIf([A.H] Is Null,"-",[A.H]) AS T,
B.A, B.B, B.C, B.D, B.E, B.F, B.G, B.H
FROM B LEFT JOIN A ON B.A = A.A AND B.B = A.B AND B.C = A.C AND B.D = A.D AND B.E = A.E AND B.F = A.F AND B.G = A.G AND B.H = A.H
WHERE (
([B].[A] Not In (SELECT B.A FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.A) Is Null)
AND ([B].[B] Not In (SELECT B.B FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.B) Is Null)
AND ([B].[C] Not In (SELECT B.C FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.C) Is Null)
AND ([B].[D] Not In (SELECT B.D FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.D) Is Null)
AND ([B].[E] Not In (SELECT B.E FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.E) Is Null)
AND ([B].[F] Not In (SELECT B.F FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.F) Is Null)
AND ([B].[G] Not In (SELECT B.G FROM B INNER JOIN A ON (A.A = B.A) AND (A.B = B.B) AND (A.C = B.C) AND (A.D = B.D) AND (A.E = B.E) AND (A.F = B.F) AND (A.G = B.G) AND (A.H = B.H)) Or (B.G) Is Null)
);
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.