Re: Dynamic SQL selection question

From: <76434.1353_at_compuserve.com>
Date: Tue, 17 Jun 2003 22:08:29 GMT
Message-ID: <3eef8ed1.29387246@news.hccnet.nl>

So thank u all but I read more complains about my way of approaching this issue than solutions.

The thing is I need to insert data from a joined files A - B into C join fields are SUN_DB & ACCOUNT_NR BUT!! file B's name is variable en this variable part of the name comes out of file A field: SUN_DB

file A: filed SUN_DB = ZZZ so A has to be joined with file
"B_ZZZ"

file A:: field SUN_DB= YYY so A has to be joined with file
"B_YYY"
there are +- 700 SUN_DB codes
Thanks, Received on Tue Jun 17 2003 - 17:08:29 CDT