is this sql statement possible?

[ajoce]

SELECT CONT.CONTID
FROM CONT WHERE CONT.ACCT_ID =
(SELECT AIDE.ACCT_ID FROM AIDE WHERE AIDE.AIDE_ID = 'AA01')

or is there an alternative in doing this? help, please..

 

[r937]

select cont.contid
  from cont 
inner
  join aide
    on cont.acct_id 
     = aide.acct_id 
 where aide.aide_id 
     = 'AA01'

rudy

http://r937.com/

SQL Consulting

 

[ajoce]

thanks =) it works. oh, on the sql statement i posted. it also worked. just remove the parenthesis ( ), and replace it with single quotes =)

thanks rudy.