I am a bit familar with SQL queries, but the Foxpro twist is causing me a few headaches.

I would expect the following query to give me a list of all fields in table a and 1 field in table b, but it renames any of the fields in table a with an _a that conflict with names in the joined table even though I am not questing them.

SELECT *,design.description FROM invitempost INNER JOIN design ON invitempost.descode = design.descode

I don't want to specifically list the fields from table a that I want because there are easily 100 fields in that table and I plan on using this sql statement in many areas and don't want to constantly have to update them. I am sure there is an easy answer.....

-Randy