Features File Geodatabase SQL helps you to

SQL on File Geodatabase

Execute simple SQL queries against File Geodatabase.

select * from {table}
order by {column}
select count(*) from {table}

Table Joins

Join data from a main table to other tables by using a join operator. 

select * from {table A} 
left join {table B} 
on {table A}.{column A}
= {table B}.{column B}.

Download

File Geodatabase SQL 1.0 is available free of charge.