OBS/Adminhilfe/Join Erläuterungen: Unterschied zwischen den Versionen

Aus OBS Wiki
Zur Navigation springen Zur Suche springen
Für diese Seite wurde eine Zugriffsbeschränkung eingerichtet. Falls du diese Nachricht siehst, bist du nicht berechtigt, diese Seite einzusehen.
(Importing text file)
Keine Bearbeitungszusammenfassung
Zeile 4: Zeile 4:


{| cellspacing="-1"
{| cellspacing="-1"
<table border=1>
|- valign="top"
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
Zeile 43: Zeile 44:
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Diners Club</div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Diners Club</div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008</div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008
|}
|}


Zeile 49: Zeile 50:


{| cellspacing="-1"
{| cellspacing="-1"
<table border=1>
|- valign="top"
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
Zeile 104: Zeile 106:
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>
|}
|}


Zeile 110: Zeile 112:


{| cellspacing="-1"
{| cellspacing="-1"
<table border=1>
|- valign="top"
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
Zeile 157: Zeile 160:
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Diners Club</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Diners Club</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008
|}
|}


Zeile 163: Zeile 166:


{| cellspacing="-1"
{| cellspacing="-1"
<table border=1>
|- valign="top"
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
Zeile 226: Zeile 230:
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>
|}
|}


Version vom 16. September 2011, 16:57 Uhr


INNER JOIN

Ergebnis
RechnungsNr
KundenNr
Betrag
Kartennummer
Firma
Inhaber
Ablaufdatum
98765
ABX039
49,95
12345
VISA
Max Mustermann
05/2007
98767
ABX040
79,95
12347
American Express
John Doe
01/2007
98768
ABX050
59,99
12347
American Express
John Doe
01/2007
98769
ABX050
29,99
12348
Diners Club
John Doe
03/2008

LEFT JOIN:

Ergebnis
RechnungsNr
KundenNr
Betrag
Kartennummer
Firma
Inhaber
Ablaufdatum
98765
ABX039
49,95
12345
VISA
Max Mustermann
05/2007
98766
ABX039
12,95
-
-
-
-
98767
ABX040
79,95
12347
American Express
John Doe
01/2007
98768
ABX050
59,99
12347
American Express
John Doe
01/2007
98769
ABX050
29,99
12348
Diners Club
John Doe
03/2008
98770
ABX060
99,99
-
-
-


RIGHT JOIN:

Ergebnis
RechnungsNr
KundenNr
Betrag
Kartennummer
Firma
Inhaber
Ablaufdatum
98765
ABX039
49,95
12345
VISA
Max Mustermann
05/2007
-
-
-
12346
Mastercard
Katrin Musterfrau
01/2008
98767
ABX040
79,95
12347
American Express
John Doe
01/2007
98768
ABX050
59,99
12347
American Express
John Doe
01/2007
98769
ABX050
29,99
12348
Diners Club
John Doe
03/2008


FULL OUTER JOIN

Ergebnis
RechnungsNr
KundenNr
Betrag
Kartennummer
Firma
Inhaber
Ablaufdatum
98765
ABX039
49,95
12345
VISA
Max Mustermann
05/2007
98766
ABX039
12,95
-
-
-
-
-
-
-
12346
Mastercard
Katrin Musterfrau
01/2008
98767
ABX040
79,95
12347
American Express
John Doe
01/2007
98768
ABX050
59,99
12347
American Express
John Doe
01/2007
98769
ABX050
29,99
12348
Diners Club
John Doe
03/2008
98770
ABX060
99,99
-
-
-



Auto import 15:35, 25. Aug. 2011 (CEST)

Abgerufen von „http:///index.php?title=OBS/Adminhilfe/Join_Erläuterungen&oldid=7221“