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