-
i am getting error too many rows
i tried chaning the where clause still
i am getting same error
let me k now u r suggestion
select flatfile_name,table_name,column_name,TYPE,length from cnv_flatfile_spec where (
SELECT table_name,column_name,TYPE,length FROM
cnv_flatfile_spec
intersect
SELECT table_name,column_name,data_type,data_length
FROM power_comp_spec)
thanks in advance
srinivas
-
In WHERE construction you must use BOOLEAN expressions.
In your case :
... where (SELECT table_name,column_name,TYPE,length FROM ...) must return 1 row with 1 boolean variable (TRUE/FALSE).
Are you sure about it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|