Special query

[lfarina]

Hello,

I am trying to use a command button on a form to allow a user to run a make-table query. The query is the problem. I have two tables, I need all the data from table A but only certain columns from table B. Both tables have a company_id that is used for the relationship. I can't just say Select * from both tables because then I get the company_id in two different columns, I dont' want that. Also The columns from table B that I do want aren't always the same, sometimes there may be 10 columns, other times there may be 80. What would I put in a SQL statement or code to say give me all columns except the company_id from table B without giving the actual column names that I do want? Thanks.

 

[AnonGod]

Just threw this together. Does this help?
I just created 2 tables each with a company_id field along with 3 other fields to test.

SELECT Table1.*, Table2.* INTO NewTable
FROM Table1 INNER JOIN Table2 ON Table1.company_id = Table2.company_id;

ALTER TABLE NewTable
DROP COLUMN Table2_company_id

-Andrew

[Signature modified by admin request]
-TAG
anongod@hotmail.com
'Drawing on my fine command of language, I said nothing.'

 

[lfarina]

Thanks for the reply Andrew, it worked!

 

[lfarina]

How would I change a column name? For the same new table the other company_id that I wanted to keep has the original table name attached to it I would like for it to simply read Company_Id.