Conditional Linking
-
Did you read your own first post?
> My Problem is the following:
> I have two tables. I need to get records from the second table where a key
> field links the two tables. If the second table has records matching this
> criteria, it's done. If for some records there is no records matching the
> whole key, i want to check for records using part of the key field (like
> first 3 charcaters).
Was it somebody else writing this?
External table is the table you are loading. It comes from another database, so it's external. And it definetely exists in your task. Unless you've changed it too.
_____________
Code for TallyGenerator -
..can't wait to see Ninja get in this...
-
Sergiy,
The first example i gave was to simplify the question and make it clear to the readers.
I said later:
QUOTE:
In fact there is one table which is imported on daily basis from a legacy system.
And links will be self joins on the same table (using different criteria for records selection). So in order to use the method that Sergiy suggested I will have to do that during the import process which i am trying to avoid, because using the update after importing the data will take the same time as running the query (which will be run once a day to extract the resulting data).
UNQOTE
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply