i have solved that problem, i had made views of grouping two tables, and gettign the results, and then using them in the final query. iam using oracle 8i

"ADMIT U...

i have done  that and waiting for answers, but there message board is not very proper, after posting u have to search for question where exactly its been posted, its...

if anybody knows what iam talking about knows the answer , can answer. 

first of all iam dont' know any oracle forums.

and iam very used to this forum, u can help if u try

what exactly iam doing is , iam making an automated response to the clients when there policy is nearing expiration,

that will require emailids,and mobilenos which is in sqlserver database, rest...

SELECT * FROM OPENROWSET('SQLOLEDB', '202.16.58.120';'dev';'user1234','SELECT * FROM onmgr_temp.dev.dept')

when i type this command in (TOAD) hope u have used toad its an enterprise manager & queryanalyzer...

pls answer my question

no dear,

not that,

my oracle server is the main database used, there is only one table which is in sql server which i need for just a temporary join

i...

first you need to select some columns who are compositely supposed to be unique, but are not.

then u need to write a query

select col1,col2,col3 from table

group by col1,col2,col3 have...

it does'nt work have you checked that query ??

how exactly pls show it??

thanks, but that problem is solved,

ya it was i had to recompile, but then the problem was in the encryption table was blank

i just needed to add the encryption key,...

does any body knows about xql queries

what are u trying to achieve and whats the purpose behind all this

have u tried this ?, what was the result