Venus AUEB Forum

Code: Select all

SELECT A.Element,B.Element 
    FROM A,B ή FROM B,A

Code: Select all

Element Element
1 a
1 b
1 c
1 d
1 e
1 f
2 a
2 b
2 c
2 d
2 e
2 f
....
5 a
5 b
5 c
5 d
5 e
5 f

Code: Select all

SELECT A.Element,C.Element 
    FROM A,C ή FROM C,A

Code: Select all

Element Element
1 #
2 #
3 #
4 #
5 #
1 $
2 $
3 $
4 $
5 $
1 %
2 %
3 %
4 %
5 %

Code: Select all

SELECT A.Element,D.Element 
    FROM A,D 

Code: Select all

Element Element
1 Α
2 Α
3 Α
4 Α
5 Α
1 Β
2 Β
3 Β
4 Β
5 Β
...
1 Ε
2 Ε
3 Ε
4 Ε
5 Ε

Code: Select all

SELECT A.Element,D.Element 
    FROM D,A 

Code: Select all

Element Element
1 Α
1 B
1 C
1 D
1 E
2 Α
2 B
2 C
2 D
2 E
...
5 Α
5 B
5 C
5 D
5 E

Code: Select all

1 a        
1 b
1 c   
1 d
1 e
1 f

vs

1 #
2 #
3 #
4 #
5 # 

Code: Select all

muliply (X, Y){
var result = 0;
 for 1 to X
       result +=Y
return result
}

Code: Select all

muliply (X, Y){
if (X>Y)
   return multiply(Y,X)
else{
var result = 0;
 for 1 to X
       result +=Y
return result
}
}

Code: Select all

select (A, B){
if (A.size<B.size) {
    for (i:1 to A.size) {
       for(j:1 to B.size) {
        print A[i]+" "+B[j]
        }
   }
}
else if (A.size>B.size) {
    for (j:1 to B.size) {
       for(i:1 to A.size) {
        print A[i]+" "+B[j] 
       }
   }
}
else {
    "Δες τους πίνακες στο FROM"
     if (προηγείται το Α) {
         for (j:1 to B.size) {
            for(i:1 to A.size) {
              print A[i]+" "+B[j]
           }
         }
     }
     else if (προηγείται το B) {
         for (i:1 to A.size) {
            for(j:1 to B.size) {
              print A[i]+" "+B[j]
           }
         }
     }
}

}