MDanz Posted August 29, 2011 Share Posted August 29, 2011 I want a query where searching for 'dave', will display the top three rows. 'mike' and 'carl' both have the parentid of dave. So the three rows displayed will be the top three. +----+----------+------------+ | id | parentid| user +----+----------+------------+ | 1 | null | dave | 2 | 1 | mike | 3 | 1 | carl | 4 | 2 | rick | 5 | 4 | mike What type of query will accomplish this? A nested query? Quote Link to comment Share on other sites More sharing options...
MDanz Posted August 29, 2011 Author Share Posted August 29, 2011 nevermind , i used an left join Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.