You can look up how to use HASH, MERGE and INNER JOIN in the online
reference for your database product. If you want us to help you write the
query though, you're going to have to give us more details about what you
want to do...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Tejo_Nemalikanti" <Tejo_Nemalikanti@s...>
To: "sql language" <sql_language@p...>
Sent: Sunday, September 09, 2001 11:46 PM
Subject: [sql_language] Advanced Join Problem


: Hi,
: I have a table(assume here as xyz) which has some 13 columns.I have data
in
: 10 columns.
: The other 3 columns I have to fill by using three different queries.
: My problem is :
: 1) In xyz table I have to take the pk and use that value in another query
: and put the results in 11th column.
: In the same way I will fill the 12th and 13th columns using 2 other
queries.
: These three queries have to be executed for all the rows in the xyz table.
: 2) How to insert data into the table   WITH OUT using cursors.
:
: I think using a advanced join query we can solve this.
: I don't know much about HASH, MERGE or INNER JOIN ...but i just tell me
: whether they are useful.
:
: Thanks & Regards,
: Tejo
:
:
:
:
:
$subst('Email.Unsub')