It's to build a simple information tree, I believe. I'm not the
implementer - the idea was bounced off me as I've had database
experience, but couldn't come up with an elegant solution.



Anyway, I think the tree is simply to show whether or not a specific
type event (col2) has been scheduled on a specific day (col1). The
additional info would include record details (like time, machine, test
type, etc.). This would be used as an indicator as to when to start a
machine, for example, kind of like a schedule. From the "overview"
tree, the user would be able to "drill down" and get more detail as the
displayed view expanded.



pbt.



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
Sent: Thursday, April 12, 2007 9:14 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] data retrieval

> We're looking to get all fields for the records that match the

criteria.

so you want to ignore all columns of data where the col1 and col2 values
are
re-iterated?
so col4, 5, 6, etc of data is meaningless? why keep it? why not
constrain
the data to unique col2, col3 values?
How do you decide that the second and third etc occurrences of col1,
col2
records have meaningless values in their col4, col5 etc fields?

anyway - a clumsy way is
a view on distinct col1, col2

try
select col1, col2,
(select first 1 col3 from table where table.col1=view.col1 and
tablecol2=view.col2 order by table.rec#)
(select first 1 col4 from table where table.col1=view.col1 and
tablecol2=view.col2 order by table.rec#)
from view

>
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> [mailto:firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com> ] On Behalf Of Nick Upson

> Sent: Thursday, April 12, 2007 8:49 AM
> To: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> Subject: Re: [firebird-support] data retrieval
>
>
>
> you can get the required values by
>
> select col1, col2 from table1
> group by col1, col2
> having count(*) = 1
>
> or
>
> select distinct col1, col2 from table1
>
> for the other parts of the records like rec# the problem is which one
> do you want?
>
> On 12/04/07, Peter Turner <PeterTurner@...

<mailto:PeterTurner%40sunnuclear.com>

> <mailto:PeterTurner%40sunnuclear.com> > wrote:
> > Mis-typed what we wanted.....meant we wanted rec #1, #2, #4, #5, #6,
> and
> > #7 - skipping #3 and #8
> >
> >
> >
> > pbt.
> >
> >
> >
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> <mailto:firebird-support%40yahoogroups.com>
> > [mailto:firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> <mailto:firebird-support%40yahoogroups.com> ] On Behalf Of Alan

McDonald

> > Sent: Wednesday, April 11, 2007 5:38 PM
> > To: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> <mailto:firebird-support%40yahoogroups.com>
> > Subject: RE: [firebird-support] data retrieval
> >
> >
> >
> > > hi,
> > >
> > > have a table with the following conceptual data...
> > > rec# col1 col2 ... coln
> > > 1 1 d data
> > > 2 1 m data
> > > 3 1 d data
> > > 4 2 d data
> > > 5 2 m data
> > > 6 3 d data
> > > 7 3 m data
> > > 8 3 d data
> > >
> > > trying to come up with a single query that would return unique
> records
> >
> > > where the combination of col1 and col2 are unique. in the example,
> > > would want rec #1, #2, #3, #4, #6, and #7.
> > >
> > > have come up with a couple of multiple query ideas, but was
> wondering
> > > how to do this in a single query (if possible).
> > >
> > > TIA,
> > >
> > > Pete Turner
> > > Sun Nuclear Corp.
> >
> > but #5 is unique too no?
> > Alan
> > try a view on ditinct col1, col2
> > then join the other data to the view
> > Alan
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org <http://www.firebirdsql.org>

<http://www.firebirdsql.org <http://www.firebirdsql.org> > and

> click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com

<http://www.ibphoenix.com>

> <http://www.ibphoenix.com <http://www.ibphoenix.com> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org <http://www.firebirdsql.org> and

click the Resources item

> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com

<http://www.ibphoenix.com>

>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]