|
Читайте также: |
Соединение естественное
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
JOIN dbo. Manager k ON C.id_cas = M.id_manager;
| name_cas | id_cas | name_manager | id_manager |
| iv | inf | ||
| pet | inf | ||
| sid | isp | ||
| aaaa | avt |
Соединения открытые
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
JOIN dbo. Manager k ON C.id_cas = M.id_manager;
AND casier.id_cas > 18
| name_cas id_cas | name_manager | id_manager | |
| iv | inf | ||
| pet | inf | v21 |
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
LEFT OUTER JOIN Casier C ON C.id_cas = M.id_manager;
| name_cas | id_cas | v name_manager | id_manager |
| iv | inf | ||
| pet | inf | ||
| sid | isp | ||
| aaaa | avt |
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
LEFT OUTER JOIN Casier C ON C.id_cas = M.id_manager;
WHERE C.id_cas > 12
| name_cas id_cas | name_manager | id_manager | |
| sid | isp | ||
| aaaa | avt |
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
FULL OUTER JOIN Manager M ON M.id_manager = M.id_manager
Декартово произведение не может содержать фильтрацию
SELECT Casier.name_cas, casier.id_cas, Manager.name_manager, Manager.id_manager
FROM dbo. Casier s
CROSS JOIN Manager M
| name_cas | id_cas | name_manager | id_manager |
| iv | inf | ||
| pet | inf | ||
| sid | inf | ||
| aaaa | inf | ||
| iv | isp | ||
| pet | isp | ||
| sid | isp | ||
| aaaa | isp | ||
| iv | avt | ||
| pet | avt | ||
| sid | avt | ||
| aaaa | avt |
Дата добавления: 2015-07-16; просмотров: 42 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Образование | | | Метизом |