Date:         Tue, 7 Mar 1995 07:52:36 -0500
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Mary Lou Arundell 556-9050
Subject:      Re: tloc question
In-Reply-To:  <199503070236.UAA04835@info.tamu.edu>

Dave:

Is this the situation you are facing:

The external file is the "left hand" table, and you need to make
a join to the NOMAD database (the "right hand" table) to get a
description for the record in the left hand table.

Is the problem that there is no date/time data on the left hand
table, or that the date/time data in the left hand table isn't
matching correctly with the date/time data in the right hand
table?

It seemed from your description that the A4 item was in both
tables and that using this item alone (not with the date/time
values) there is a one to many or many to many relationship
between the tables.

Can you say if this is the situation, or if not, clarify your
situation a little more?

Mary Lou

marylou.arundell@uc.edu
University of Cincinnati
back to index