Rauldinho
03-21-2007, 01:20 PM
Hi, i want to create a view that gets the data from a table but using different selects :confused:. Here is an example:
ID VALUE TIME
1 A 13.01
2 B 15.23
1 C 17.12
2 A 22.07
3 D 19.48
1 B 23.11
2 F 12.40
I will use 3 select to get the last row inserted from the 3 ID (1,2,3). In this case i would get a new table like this one:
ID VALUE TIME
1 B 23.11
2 A 22.07
3 D 19.48
As you can see, the values are the most recent (taking the time from a same day :) ) . So my question is something like, how can i create this view from joining the result from this 3 selects?? Thanks for any answer, and sorry for my english.
ID VALUE TIME
1 A 13.01
2 B 15.23
1 C 17.12
2 A 22.07
3 D 19.48
1 B 23.11
2 F 12.40
I will use 3 select to get the last row inserted from the 3 ID (1,2,3). In this case i would get a new table like this one:
ID VALUE TIME
1 B 23.11
2 A 22.07
3 D 19.48
As you can see, the values are the most recent (taking the time from a same day :) ) . So my question is something like, how can i create this view from joining the result from this 3 selects?? Thanks for any answer, and sorry for my english.