Re: Query problem

From: <jlaroche_at_em.agr.ca>
Date: 1998/11/06
Message-ID: <71usg1$uv1$1@nnrp1.dejanews.com>#1/1

In article <71tr1o$30a$1_at_news1-alterdial.uu.net>,   "Matt Lieber" <lieber_at_ilog.com> wrote:
> Hi,
>
> I make a query on my database that returns the expected result, except
> that some value are duplicated (although the row is unique).
> e.g.:
> name x y card
> -------------------------------- ----------- ----------- -------------------
> -------------
> Berkshire 48 160 C1
> Berkshire 48 160 C2
> Cape 48 160 C3
> Cape 48 160 C4
>
> How can I get only the 2 rows that differ by their names (that is, Berkshire
> and Cape)?? That is, some way to say: "no duplicates in name".
> e.g.:
> name x y
> -------------------------------- ----------- -----------
> Berkshire 48 160
> Cape 48 160
>
> my query looks like this:
> select nodes.name,x,y from nodes, nodecoordinates where mapview=2
>
> any ideas?
>
> Thanks!!
> Matt
>
>

I guess there is a relation missing in you where clause. Something like nodes.key = nodecoordinates.key.

Key is the table key in this example.

---

Jonathan Laroche
Consultant - Software Developer
jlaroche_at_em.agr.ca

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 00:00:00 CST