Re: [ADMIN] [SQL Question] Selecting distinct rows having field value pairs on semantics

2006-10-03 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Allan Kamau <[EMAIL PROTECTED]> writes: > Hi all, > I am looking for a way of selecting records from a > table comprising of pairing fields having unique > semantics, where the pair of values of lets say 'left' > and 'right' and another pair having values of 'right'

[ADMIN] [SQL Question] Selecting distinct rows having field value pairs on semantics

2006-10-03 Thread Allan Kamau
Hi all, I am looking for a way of selecting records from a table comprising of pairing fields having unique semantics, where the pair of values of lets say 'left' and 'right' and another pair having values of 'right' and 'left' is considered as duplicates as they have the same meaning. Below is m