ich versuch mal einen anfang zu machen
0: SELECT A1,A2,...,Ak FROM R
1: SELECT * FROM R WHERE P
2: SELECT * FROM R,S
3: SELECT * FROM R INNER JOIN S ON R.a=S.b
4:
5: SELECT * FROM R LEFT JOIN S ON R.a=S.b
6: SELECT * FROM R UNION JOIN S
7: SELECT * FROM R UNION SELECT * FROM S
8: SELECT * FROM R INTERSECT SELECT * FROM S
9: SELECT * FROM R EXCEPT SELECT * FROM S
A: SELECT * FROM R WHERE NOT EXISTS (SELECT * FROM S)
__________________
GS 500E .. '01-'?? .. alles original
|