Help- Oracle Kathulu ..pls Come

[Mr Mirchi]

user_temp and business_users has id and password...id is same , but password is different. So, I should be results when I run below queries....

 

 select * from user_temp where id in (select id from business_users where id = '16692018')

 and password not in (select password from business_users where id = '16692018')

 

The above query returns 1 record which is correct. If I run below query without id, then I am not getting any results...why???

 

 

 select * from user_temp where id in (select id from business_users )

 and password not in (select password from business_users)

 

 

--> can we write above query like this?..this runs fast and give me results.

 

 select temp.id from user_temp temp, business_users  business

 where temp.id = business.id

 and temp.password != business.password

 

 

 

 

Thanks

[Mr Mirchi]

found it....i  m good thanks

[zoombi]

Ans kuda cheppu....evvariko okkariki help avutundhi

 

[spidereddy]

Ans kuda cheppu....evvariko okkariki help avutundhi

adho thokkalo ques malli dhaniki ans

[ipaddress0]

Ans kuda cheppu....evvariko okkariki help avutundhi

+1