Joining
Posted: Tue Mar 30, 2004 8:07 am
I have two tables like
Table A
Index1, Index2, Location
Table B
Index1, Index2, Result_type, Result
(So each row represents one result_type & result pair)
And i'd like to have a table like
Index1, Index2, Location, Result, Result, Result...
(Where all results are inserted in predefined resulttype columns like Tempereture, Oxygen etc...)
Table A
Index1, Index2, Location
Table B
Index1, Index2, Result_type, Result
(So each row represents one result_type & result pair)
And i'd like to have a table like
Index1, Index2, Location, Result, Result, Result...
(Where all results are inserted in predefined resulttype columns like Tempereture, Oxygen etc...)