Hello everyone!
I've been using Java for a number of years, and now I'm at the beginning again with VB.NET.
How would I go about joining two tables?
- order doesn't matter, as long as i can print/display the order
Here's an example of what I'd like to do:
table 1
data 1 , data 2 , date time
12 , 23 , 2010/8/20 10:00:00
12 , 25 , 2010/8/20 10:01:00
13 , 24 , 2010/8/20 10:02:00
table 2
date 3 , data 4 , date time
2.2 , 12.5 , 2010/8/20 10:00:00
2.4 , 12.5 , 2010/8/20 10:01:00
2.3 , 13.1 , 2010/8/20 10:03:00
result table
data 1 , data 2 , data 3 , data 4 , date time
12 , 23 , 2.2 , 12.5 , 2010/8/20 10:00:00
12 , 25 , 2.4 , 12.5 , 2010/8/20 10:01:00
13 , 24 , __ , __ , 2010/8/20 10:02:00
__ , __ , 2.3 , 13.1 , 2010/8/20 10:03:00
Any input would be greatly appreciated.
Thanks!
I've been using Java for a number of years, and now I'm at the beginning again with VB.NET.
How would I go about joining two tables?
- order doesn't matter, as long as i can print/display the order
Here's an example of what I'd like to do:
table 1
data 1 , data 2 , date time
12 , 23 , 2010/8/20 10:00:00
12 , 25 , 2010/8/20 10:01:00
13 , 24 , 2010/8/20 10:02:00
table 2
date 3 , data 4 , date time
2.2 , 12.5 , 2010/8/20 10:00:00
2.4 , 12.5 , 2010/8/20 10:01:00
2.3 , 13.1 , 2010/8/20 10:03:00
result table
data 1 , data 2 , data 3 , data 4 , date time
12 , 23 , 2.2 , 12.5 , 2010/8/20 10:00:00
12 , 25 , 2.4 , 12.5 , 2010/8/20 10:01:00
13 , 24 , __ , __ , 2010/8/20 10:02:00
__ , __ , 2.3 , 13.1 , 2010/8/20 10:03:00
Any input would be greatly appreciated.
Thanks!