if ($sqlSwitch == 'simple Join') {
$sql = "
SELECT * FROM testCompanies JOIN testEmployees";
}
else if ($sqlSwitch == 'left Join'){
$sql = "
SELECT * FROM testCompanies AS a LEFT JOIN testEmployees AS b ON (a.ID = b.companyID)";
}
else if ($sqlSwitch == 'right Join'){
$sql = "
SELECT * FROM testCompanies AS a RIGHT JOIN testEmployees AS b ON (a.ID = b.companyID)";
}
else if ($sqlSwitch == 'left with ID'){
$sql = "
SELECT * FROM testCompanies LEFT JOIN testEmployees USING (ID)";
}
else {
$sql = "SELECT * FROM testCompanies as A , testEmployees AS B WHERE A.ID = B.companyID";
}
Der Betreiber von www.dBooks.de übernimmt keine
Verantwortung für den Inhalt und die Richtigkeit der Angaben auf
den verlinkten Websites.
Zu den üblichen NoNos gibt es keine direkten Verweise.