pedro at plex.nl
pedro at plex.nl
Thu Dec 16 11:57:58 CST 2010
Dear List, i have the following table: ID PatNr Date Name code1 code2 1 01 1-1-2010 A 1 1 2 01 2-2-2010 B 1 3 01 2-2-2010 C 1 4 02 5-1-2010 A 1 5 02 5-1-2010 C 1 I need: 2 01 2-2-2010 B 1 3 01 2-2-2010 C 1 I tried several query's with groups on PatNr and Date, but i don't get it done. Who can help me? Thanks Pedro