SELECT Umpires.ID, Umpires.FirstName, Umpires.LastName, Umpires.Phone1, Umpires.Phone2, Umpires.Level, Umpires.Status, Umpires.UmpireID, sb_umpires.city as city, sb_umpires.regdate as regdate, sb_umpires.carddate as carddate FROM Umpires LEFT JOIN sb_umpires ON Umpires.UmpireID = sb_umpires.softballid WHERE Umpires.ID = #umpireid#;

Umpire Details

Umpire ID
#Umpires.UMPIREID# 
First Name
#Umpires.FIRSTNAME# 
Last Name
#Umpires.LASTNAME# 
City
#umpires.CITY# 
Phone
#Umpires.PHONE1# 
Phone2
#Umpires.PHONE2# 
Registration Date
#DateFormat(Umpires.REGDATE,'mm/dd/yy')# 
Carded Date
#DateFormat(Umpires.CARDDATE,'mm/dd/yy')# 
Carded Level
#Umpires.LEVEL# 

 

Full List of Umpires

Fee Structure