DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Stat.

  1. #1
    Join Date
    Nov 2001
    Posts
    12
    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


  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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
  •  


Click Here to Expand Forum to Full Width