On Thu, Nov 27, 2008 at 9:32 AM, Kenneth Gonsalves <[EMAIL PROTECTED]>wrote:
> On Thursday 27 November 2008 09:27:55 am Ramar K wrote: > > i want to display grant father ,father ,sun and grand sun of kumar. > > you mean grandfather, father, son and grandson - please do a spellcheck > otherwise even google search will not work I am really sorry for that spell mistake. > > > > kumar----->raj (kumar refered by raj) > > raj --------->ram (raj refered by ram) > > kumar------>ragu(ragu refered by kumar) > > ragu ------->rajesh (rajesh refered by ragu) > > > > This is one my requirement .I want to do this without using joint query . > > try sub selects select referal_name from customers where cust_name=(select referal_name from customers where cust_name=(select referal_name from customers where cust_name='kumar')); I am using this query to display ram and raj . Is it correct way . please correct me any thing wrong . can i get any URL related to this. Thanks for your time Rg Ramar _______________________________________________ To unsubscribe, email [EMAIL PROTECTED] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
