HP3000-L Archives

February 2003, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Hornberger <[log in to unmask]>
Reply To:
Date:
Wed, 19 Feb 2003 14:10:07 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (34 lines)
Tom Root from Desertschools.org asked on 2/19/03:

>Does Query have a way to Join two datasets using two fields?

>I'm looking for something like:

>   Join DataSet1 to DataSet2 where
>     DataSet1.FieldA = DataSet2.FieldX  ** AND **
>     DataSet1.FieldB = DataSet2.FieldY

Tom,

I believe you can do what you want using the "multifind" command followed
by the "report" command in Query.  At the Query prompt type "HELP MU"  or
"HELP RE" and it will display the use and parameters for these commands.

HTH,

John Hornberger
Sr. Systems Programmer
SPX Global Information Services

The information contained in this electronic mail transmission is intended
by SPX Corporation for the use of the named individual or entity to which
it is addressed, and may contain information that is confidential or
privileged.  If you have received this electronic mail transmission in
error, please delete it from your system without copying or forwarding it,
and notify the sender of the error by reply mail or call the SPX GIS Help
Desk at 215-293-2811 so that the sender's address records can be
corrected.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2