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)
K (hat „SQLJOIN“ nach „OBS/Adminhilfe/Join Erläuterungen“ verschoben)
 
(7 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<font face="Arial"><font size="2"><br /></font></font><font face="Arial">'''<font size="2">INNER JOIN<br /></font>'''</font><font face="Arial"><font size="2"><br /></font></font><font face="Arial"><font size="2">Ergebnis<br /></font></font><font face="Arial"><font size="2"></font></font>
{{ZugriffOBS}}<font size="2" color="#000000" face="Arial"> </font>


{| border="2"
=INNER JOIN=
| <font face="Arial">'''<font size="2"><center> RechnungsNr</center></font>'''</font>
<div>Ergebnis</div><div>
| <font face="Arial">'''<font size="2"><center>KundenNr</center></font>'''</font>
 
| <font face="Arial">'''<font size="2"><center>Betrag</center></font>'''</font>
{| cellspacing="-1"
| <font face="Arial">'''<font size="2"><center>Kartennummer</center></font>'''</font>
<table border=1>
| <font face="Arial">'''<font size="2"><center>Firma</center></font>'''</font>
|- valign="top"
| <font face="Arial">'''<font size="2"><center>Inhaber</center></font>'''</font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| <font face="Arial">'''<font size="2"><center>Ablaufdatum</center></font>'''</font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''KundenNr'''</center></div></font>
|-
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Betrag'''</center></div></font>
| <font face="Arial"><font size="2">98765</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Kartennummer'''</center></div></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Firma'''</center></div></font>
| <font face="Arial"><font size="2">49,95</font></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Inhaber'''</center></div></font>
| <font face="Arial"><font size="2">12345</font></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Ablaufdatum'''</center></div></font>
| <font face="Arial"><font size="2">VISA</font></font>
|- valign="top"
| <font face="Arial"><font size="2">Max Mustermann</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98765</div></font>
| <font face="Arial"><font size="2">05/2007</font></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
|-
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>49,95</div></font>
| <font face="Arial"><font size="2">98767</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12345</div></font>
| <font face="Arial"><font size="2">ABX040</font></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>VISA</div></font>
| <font face="Arial"><font size="2">79,95</font></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Max Mustermann</div></font>
| <font face="Arial"><font size="2">12347</font></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>05/2007</div></font>
| <font face="Arial"><font size="2">American Express</font></font>
|- valign="top"
| <font face="Arial"><font size="2">John Doe</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98767</div></font>
| <font face="Arial"><font size="2">01/2007</font></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX040</div></font>
|-
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>79,95</div></font>
| <font face="Arial"><font size="2">98768</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</div></font>
| <font face="Arial"><font size="2">59,99</font></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| <font face="Arial"><font size="2">12347</font></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>01/2007</div></font>
| <font face="Arial"><font size="2">American Express</font></font>
|- valign="top"
| <font face="Arial"><font size="2">John Doe</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98768</div></font>
| <font face="Arial"><font size="2">01/2007</font></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
|-
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>59,99</div></font>
| <font face="Arial"><font size="2">98769</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</div></font>
| <font face="Arial"><font size="2">29,99</font></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| <font face="Arial"><font size="2">12348</font></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>01/2007</div></font>
| <font face="Arial"><font size="2">Diners Club</font></font>
|- valign="top"
| <font face="Arial"><font size="2">John Doe</font></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98769</div></font>
| <font face="Arial"><font size="2">03/2008</font></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
|-
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>29,99</div></font>
| <font face="Arial"><font size="2"><br /></font></font><font face="Arial">'''<font size="2">LEFT JOIN:<br /></font>'''</font><font face="Arial"><font size="2"><br /> Ergebnis<br /></font></font><font face="Arial"><font size="2"></font></font><font face="Arial">'''<font size="2"><center> RechnungsNr</center></font>'''</font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12348</div></font>
| <font face="Arial">'''<font size="2"><center>KundenNr</center></font>'''</font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Diners Club</div></font>
| <font face="Arial">'''<font size="2"><center>Betrag</center></font>'''</font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>John Doe</div></font>
| <font face="Arial">'''<font size="2"><center>Kartennummer</center></font>'''</font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008
| <font face="Arial">'''<font size="2"><center>Firma</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Inhaber</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Ablaufdatum</center></font>'''</font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98765</font></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| <font face="Arial"><font size="2">49,95</font></font>
| <font face="Arial"><font size="2">12345</font></font>
| <font face="Arial"><font size="2">VISA</font></font>
| <font face="Arial"><font size="2">Max Mustermann</font></font>
| <font face="Arial"><font size="2">05/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98766</font></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| <font face="Arial"><font size="2">12,95</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98767</font></font>
| <font face="Arial"><font size="2">ABX040</font></font>
| <font face="Arial"><font size="2">79,95</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98768</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">59,99</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98769</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">29,99</font></font>
| <font face="Arial"><font size="2">12348</font></font>
| <font face="Arial"><font size="2">Diners Club</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">03/2008</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98770</font></font>
| <font face="Arial"><font size="2">ABX060</font></font>
| <font face="Arial"><font size="2">99,99</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
|-
| <font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2"><br /><br /> RIGHT JOIN:<br /><br /> Ergebnis<br /></font></font><font face="Arial"><font size="2"></font></font><font face="Arial">'''<font size="2"><center> RechnungsNr</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>KundenNr</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Betrag</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Kartennummer</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Firma</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Inhaber</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Ablaufdatum</center></font>'''</font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98765</font></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| <font face="Arial"><font size="2">49,95</font></font>
| <font face="Arial"><font size="2">12345</font></font>
| <font face="Arial"><font size="2">VISA</font></font>
| <font face="Arial"><font size="2">Max Mustermann</font></font>
| <font face="Arial"><font size="2">05/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">12346</font></font>
| <font face="Arial"><font size="2">Mastercard</font></font>
| <font face="Arial"><font size="2">Katrin Musterfrau</font></font>
| <font face="Arial"><font size="2">01/2008</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98767</font></font>
| <font face="Arial"><font size="2">ABX040</font></font>
| <font face="Arial"><font size="2">79,95</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98768</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">59,99</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2">98769</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">29,99</font></font>
| <font face="Arial"><font size="2">12348</font></font>
| <font face="Arial"><font size="2">Diners Club</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">03/2008</font></font>
|-
| <font face="Arial"><font size="2"></font></font>
|-
| <font face="Arial"><font size="2"><br /><br /></font></font>
|}
|}


<font face="Arial">'''<font size="2">FULL OUTER JOIN<br /></font>'''</font><font face="Arial"><font size="2"><br /></font></font><font face="Arial"><font size="2">Ergebnis<br /></font></font><font face="Arial"><font size="2"></font></font>
=LEFT JOIN:=
<div>Ergebnis</div><div>
 
{| cellspacing="-1"
<table border=1>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''KundenNr'''</center></div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Betrag'''</center></div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Kartennummer'''</center></div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Firma'''</center></div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Inhaber'''</center></div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Ablaufdatum'''</center></div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98765</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>49,95</div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12345</div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>VISA</div></font>
| width="110" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Max Mustermann</div></font>
| width="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>05/2007</div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98766</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12,95</div></font>
| width="95" 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="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98767</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX040</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>79,95</div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98768</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>59,99</div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="125" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98769</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>29,99</div></font>
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12348</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="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008</div></font>
|- valign="top"
| width="95" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98770</div></font>
| width="64" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX060</div></font>
| width="49" valign="middle" | <font size="2" color="#000000" face="Arial"><div>99,99</div></font>
| width="95" 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="87" valign="middle" | <font size="2" color="#000000" face="Arial"><div>
|}
 
=RIGHT JOIN:=
<div>Ergebnis</div><div>
 
{| cellspacing="-1"
<table border=1>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''KundenNr'''</center></div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Betrag'''</center></div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Kartennummer'''</center></div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Firma'''</center></div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Inhaber'''</center></div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Ablaufdatum'''</center></div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98765</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>49,95</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12345</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>VISA</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Max Mustermann</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>05/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12346</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Mastercard</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Katrin Musterfrau</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>01/2008</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98767</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX040</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>79,95</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98768</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>59,99</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98769</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>29,99</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12348</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="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008
|}
 
=FULL OUTER JOIN=
<div>Ergebnis</div><div>
 
{| cellspacing="-1"
<table border=1>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>''' RechnungsNr'''</center></div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''KundenNr'''</center></div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Betrag'''</center></div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Kartennummer'''</center></div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Firma'''</center></div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Inhaber'''</center></div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div><center>'''Ablaufdatum'''</center></div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98765</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>49,95</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12345</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>VISA</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Max Mustermann</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>05/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98766</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX039</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12,95</div></font>
| width="91" 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="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>-</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12346</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Mastercard</div></font>
| width="128" valign="middle" | <font size="2" color="#000000" face="Arial"><div>Katrin Musterfrau</div></font>
| width="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>01/2008</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98767</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX040</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>79,95</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98768</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>59,99</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12347</div></font>
| width="120" valign="middle" | <font size="2" color="#000000" face="Arial"><div>American Express</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>01/2007</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98769</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX050</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>29,99</div></font>
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>12348</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="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>03/2008</div></font>
|- valign="top"
| width="91" valign="middle" | <font size="2" color="#000000" face="Arial"><div>98770</div></font>
| width="62" valign="middle" | <font size="2" color="#000000" face="Arial"><div>ABX060</div></font>
| width="48" valign="middle" | <font size="2" color="#000000" face="Arial"><div>99,99</div></font>
| width="91" 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="84" valign="middle" | <font size="2" color="#000000" face="Arial"><div>
|}


{| border="2"
</div><br /><br />[[Category:html]]
| <font face="Arial">'''<font size="2"><center> RechnungsNr</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>KundenNr</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Betrag</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Kartennummer</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Firma</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Inhaber</center></font>'''</font>
| <font face="Arial">'''<font size="2"><center>Ablaufdatum</center></font>'''</font>
|-
| <font face="Arial"><font size="2">98765</font></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| <font face="Arial"><font size="2">49,95</font></font>
| <font face="Arial"><font size="2">12345</font></font>
| <font face="Arial"><font size="2">VISA</font></font>
| <font face="Arial"><font size="2">Max Mustermann</font></font>
| <font face="Arial"><font size="2">05/2007</font></font>
|-
| <font face="Arial"><font size="2">98766</font></font>
| <font face="Arial"><font size="2">ABX039</font></font>
| <font face="Arial"><font size="2">12,95</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
|-
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">12346</font></font>
| <font face="Arial"><font size="2">Mastercard</font></font>
| <font face="Arial"><font size="2">Katrin Musterfrau</font></font>
| <font face="Arial"><font size="2">01/2008</font></font>
|-
| <font face="Arial"><font size="2">98767</font></font>
| <font face="Arial"><font size="2">ABX040</font></font>
| <font face="Arial"><font size="2">79,95</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2">98768</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">59,99</font></font>
| <font face="Arial"><font size="2">12347</font></font>
| <font face="Arial"><font size="2">American Express</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">01/2007</font></font>
|-
| <font face="Arial"><font size="2">98769</font></font>
| <font face="Arial"><font size="2">ABX050</font></font>
| <font face="Arial"><font size="2">29,99</font></font>
| <font face="Arial"><font size="2">12348</font></font>
| <font face="Arial"><font size="2">Diners Club</font></font>
| <font face="Arial"><font size="2">John Doe</font></font>
| <font face="Arial"><font size="2">03/2008</font></font>
|-
| <font face="Arial"><font size="2">98770</font></font>
| <font face="Arial"><font size="2">ABX060</font></font>
| <font face="Arial"><font size="2">99,99</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
| <font face="Arial"><font size="2">-</font></font>
|-
| <font face="Arial"><font size="3"><br /><br /></font></font><font face="Arial"><font size="2"></font></font><font face="Arial"><font size="2"></font></font>
|}[[Category:hilfe]]
----
----
[[Spezial:Beiträge/Auto import|Auto import]] 16:07, 5. Jul. 2011 (CEST)
[[Benutzer:Auto import|Auto import]] 15:35, 25. Aug. 2011 (CEST)

Aktuelle Version vom 2. Januar 2012, 13:50 Uhr

Dies ist eine zugriffsgeschützte Seite.


Admin-Hilfe

FAQ
FIBU
Häufige Fehler FAQs
Allgemeines
Tools
Widgets
Wiki Hilfe
Syntax
Wiki-Gruppen Benutzerlisten
MySQL
MySQL Installation
Programmierung und Mergen
Delphi
Einrichtung
MMX
Git/SmartGit
Programm Update
Schaltflächen
F10: Weitere Funktionen
PAX
Nützliche Funktionen
SteVe
OBS-Administration / Installation
Einrichtung
MySQL
OBS
Dienste
Kasse/Notfallkasse
Replikation
Zentrale
Fleet-Management einrichten
VirtualUI
OBS Umzug
Admin Funktionen
Service Firmen
F10
O Support
D Programmierer-Tools
V Crypt Autologin Edit
J Update Marko Lib/Pmode/Script Lib
kundenspezifische Anpassungen
OBS Protokolle
OBS DEMO
Shop-Administration
modified eCommerce
modified eCommerce 2.x
modified eCommerce 1.06
Amazon
VShop 4.0
Kundeninformationen
OfficeStar
MDS

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=13116“