I have a table that lists numbers and gives them a rank either 'A' or 'B'. There is a ranking of 'C' if the number is not in this table.
I have another that lists numbers.
It is very easy to find which number is A or B or C, or A and B. But if i wanted to find A and C, or B and C, I cannot figure out a sql statement that would give me that.
This is probably very simple, but I am not the best at sql and so cannot wrap my head around it.
Thanks in advance
pgsql-novice by date
|Next:||From: Oliver Elphick||Date: 2002-09-11 21:44:47|
|Subject: Re: Strange situation with two tables.|
|Previous:||From: reshat.sabiq.1||Date: 2002-09-11 17:36:39|
|Subject: Changing default user's passwd|