Well, I've had a lot of help from the nug and the RB Forum. Thanks to
everyone who helped. I used this code (from Mike at the RB Db Forum)
to get the results i wanted:
SELECT student.name FROM student, link WHERE link.pid=student.id AND
link.cid in ('A','B') group by student.id having count(*) > 1
Now, I can finally eat some lunch. Thanks again.
--
Sean McCollum
Mac OS 10.4.7
RB 2006 r3 Pro
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
