Hi, I have a table like this
create table clinical_data ( group_def text, item_def text, value text ); Assuming this example data... GROUP_DEF, ITEM_DEF, VALUE --------------------------------------------------- "MEDHIST", "BODSYS", "foo" "MEDHIST", "TERM", "bar" "MEDHIST", "ONSET", "baz" I'd like to create a view that looks like BODSYS, TERM, ONSET --------------------------------------- "foo", "bar", "baz" I've got a feeling the answer lies in outer joins but my SQL is a little rusty. This seems like something people would need to do a lot. Is there a name for this that I can go lookup? Many Thanks, Andy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users