# --------------------------------------------------------------
# sample for xtab.pl
# creates a cross-tabulation having locations as rows
# and gender items as columns
# --------------------------------------------------------------
# usage: perl xtab.pl < location-gender-count.xtab [| mysql -t ]
# --------------------------------------------------------------
title=location-gender
database=xcompany
row_name=location
row_alias=town
col_name=gender
	col_alias=gender
col_value=1
col_from=FROM employees
col_where=
col_order=
row_from=FROM locations INNER JOIN employees USING(loc_code) 
row_where=
row_order=ORDER BY loc_sort_order
row_group=group by location