Home » RDBMS Server » Server Administration » the in clause
the in clause [message #373097] Tue, 27 March 2001 11:24 Go to next message
Karthik
Messages: 63
Registered: February 2000
Member
select ename from emp where ename in(select ename from emp1 where edesig='ACC')
the out come should be what ever the similar names in the two tables(emp1 edesig acc only) & check with the first querry. but it is giving some error. what other kind of clause are there some eg is most welcome

rgds
karthik
karthik_dombs@yahoo.com

Report message to a moderator

Re: the in clause [message #373119 is a reply to message #373097] Wed, 28 March 2001 08:22 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

u can try this
select ename from emp where emp,emp1 where
emp1.ename=emp.ename;

Cheers,
Balu

Report message to a moderator

Previous Topic: CASE STATEMENT
Next Topic: Re: Finding Orphan Records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:18:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.