Are the water pumps the same in a 1997 Nissan xe pick up and a 1993 same engine?

Yes, the water pumps are the same for Nissan Pickups with the KA24E (4 cyl) engine in the year range 1990 to 1997 (OE # 21010-40F27). The 1998-9/2004 Nissan Frontier with KA24DE also uses the same water pump. (OE # 21010-86G00 supercedes to 21010-40F27).