>Can we do cross tab query using SQL only? no _GENXTAB
>
>I want to do the following"
>
>city1 date1
>city1 date2
>city1 date3
>city2 date1
>city2 date2
>
>to
>city1 date1 date2 date3
>city2 date1 date2
>
>Mo

In SQL Server 2005 and up look at the PIVOT command.

In VFP check FastXTab instead of _GenXTab.