| To: | "REALbasic NUG" <realbasic-nug at lists dot realsoftware dot com> |
|---|---|
| Subject: | Re: Re: SQL Select |
| From: | "Sean McCollum" <seanmccollum at gmail dot com> |
| Date: | Mon, 31 Jul 2006 12:37:01 -0500 |
| Delivered-to: | listarchive at realsoftware dot com |
| Delivered-to: | realbasic-nug at lists dot realsoftware dot com |
| Domainkey-signature: | a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=M4fw4cZnHuHGGcJ6D/csODbTlSV6EmtK1hF8r4UnGwfGlDwAvxdHWNK0mcTF9sOHXIQk6RlsKO5eh/oqawoRsnTqfIqvyi6m7y9rTXTZXnIpP0KizkG6kgiDV+EXk/jjCsujuRKVtQXln5Gv1wvxVw/1ygq2kUA3CciA/NtyBXY= |
| References: | <20060731161227 dot ED82113E6405 at lists dot realsoftware dot com> <C0F3F7AC dot 11B70%REALbasicNUG2003 dot 001 at toolbox dot uk dot com> |
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>
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: SQL Select, Narinder Chandi |
|---|---|
| Next by Date: | [ANN] SEEdit Maxi 4.9 available, Sven E Olsson |
| Previous by Thread: | Re: SQL Select, Narinder Chandi |
| Next by Thread: | Is there a way to get xml pretty printed in RB?, Kevin Windham |
| Indexes: | [Date] [Thread] [Top] [All Lists] |