MySQL Forums :: Sample Database (Sakila) :: Sql query
Sql query
Posted by: vishnu patil ()
Date: November 29, 2012 12:46PM
Hi,
I have table having two column tid,parent
data is mapped as chiled, parent like (tid, parent) (800,0)(810,800)(820,800)(811,810)(811,6457)(808,0)(830,808)(840,808)(5524,830) so on
i want to get data all tid of 807 or 808 etc
this list i need to use in other query's where condition
i try to write function using Group Concat it is fetching records if function directly run but in where codition it is not working
Please help it is urgen
I have table having two column tid,parent
data is mapped as chiled, parent like (tid, parent) (800,0)(810,800)(820,800)(811,810)(811,6457)(808,0)(830,808)(840,808)(5524,830) so on
i want to get data all tid of 807 or 808 etc
this list i need to use in other query's where condition
i try to write function using Group Concat it is fetching records if function directly run but in where codition it is not working
Please help it is urgen
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Sql query | 677 | vishnu patil | 11/29/2012 12:46PM |
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.
© 2013, Oracle Corporation and/or its affiliates