Hi all,

I have mytable.dbf that contains 2 fields :

transitNo region

00001 NY
00001 CA
00001 FL
00001 CO

00002 CA
00002 NY
00002 FL
00002 CO

How to use SQL statments to have newtable ? with 5 fields like Pivot table
in Access or Excel to become :

Newtable :

transitNo NY CA FL CO
00001 yes yes yes yes

00002 yes yes yes yes

Tia for any help in coding with SQL .