MySQL Forums
Forum List  »  Newbie

Select Query
Posted by: Gopi L
Date: November 05, 2009 07:51AM

Hi I have a table with 5 columns. And there is a "select count(*) from another_table..." query in one of the field, assume its col5. By running this query it will return a zero or non zero.

I wanted to run a query like

SELECT * FROM T1 WHERE COL1=1 AND COL2='N' AND COL5>0 - where col5 result would be the result of executing the query inside it.

How do I do this? Any suggestions please...

Options: ReplyQuote


Subject
Written By
Posted
Select Query
November 05, 2009 07:51AM
November 05, 2009 08:16AM
November 06, 2009 12:03AM
November 06, 2009 03:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.