Easy : several ways of querying

This can be asked in your interviews.
I have two tables T1 and T2. T1 has column ID1 and has only serial numbers. T1 has column ID2 and contains only odd numbers.
T1
ID1
1
2
3
4
5
6
7
8
9
10

T2
ID2
1
2
3
4
5

Select only even numbers from T1 using T2. Write 2-3 methods.

No comments:

Post a Comment