Hey all, I've got a question about how to design my database. I have
all this census data (around 500 fields) for every city in the us, and
I'd like to be able to run queries that retrieve a subset of these
fields (maybe like 100 of them) for a given city. How should I do
this? Is it best to have a massive table with 500 rows and thousands
of columns or somehow divide it into several tables and join them all
together when I do a query?

How about if I need ALL the columns in one query?

Thanks,

Kevin