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
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
Previous Topic: CASE STATEMENT
Next Topic: Re: Finding Orphan Records
Goto Forum:
  


Current Time: Mon Dec 23 06:04:05 CST 2024