Newbie SQL Question - finding multiple records
Posted on 2005-05-17
I have a table called DRAWINGS there are two fields in DRAWINGS, DRAWNO and REV
The DRAWNO is 25 char string and REV is a one character string. The REV (revision) can be A, B or C
How I can I find out all the DRAWNO that have both an A and B revision. (in different records obviously)
I suspect it needs to group by DRAWNO but I am lost.
This is probably simple but I just need some SQL statements to get me started
TIA - NaomiG