there should be jeff let me think.... my SQL is a bit rusty.

SELECT a.bID , a.cID, a.val_timestamp, a.data_char (name of col), b.bID , b.cID, b.val_timestamp,b.data_float, c.bID , c.cID, c.val_timestamp, c.data_int AS a=data_char, b=data_float, c=data_int WHERE a.bID == b.bID && a.bID==c.bID
^^^ should work else you need to use the JOIN command, maybe Bok can help ya out a bit more since he works with it more often than me.