hi all,
i have the following table

P_id Fname Lname

1 vaibhav shukla 
2 davalesh barak
 2 sumo barath
 3 kushal mehra

now i want a query which returns any of the following table

P_id Fname Lname

1 vaibhav shukla
 2 davalesh barak 
3 kushal mehra

OR

P_id Fname Lname

1 vaibhav shukla
 2 sumo barath
 3 kushal mehra

quick solution appreciated


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3264
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6

Reply via email to