-5
select a.NAME_
    ,b.EXECUTION_ID_
    ,b.CREATE_TIME_
    ,a.TEXT_ 
from ACT_RU_VARIABLE a 
    inner join ACT_RU_TASK b on a.EXECUTION_ID_=b.EXECUTION_ID_ 
where a.NAME_= 'ticketId' 
    and b.CREATE_TIME_ in (select created_date 
                               ,priority 
                           from help_desk_ticket) ;
M0rtiis
  • 3,676
  • 1
  • 15
  • 22
syed adamshafi
  • 11
  • 1
  • You could have googled this, and your title has lost part of the error message. – philipxy Aug 08 '15 at 08:48
  • possible duplicate of [MySQL Syntax error message "Operand should contain 1 column(s)"](http://stackoverflow.com/questions/456644/mysql-syntax-error-message-operand-should-contain-1-columns) – philipxy Aug 08 '15 at 08:50

1 Answers1

1

it expects a single row from your subquery. remove priority from there:

select a.NAME_, b.EXECUTION_ID_, b.CREATE_TIME_, a.TEXT_ 
from ACT_RU_VARIABLE a 
inner join ACT_RU_TASK b on a.EXECUTION_ID_=b.EXECUTION_ID_ 
where 
    a.NAME_= 'ticketId' 
    and b.CREATE_TIME_ in (select created_date from help_desk_ticket)