Hi,

I'm trying to create a SQL statement to combine tables. I'm not sure if I have to do any joining. The tables all contain the same information with the same fields: Command, Description, Input, etc... They are only separated into multiple tables for classification. So I want the SQL statement to combine the tables and sort all the entries.

I currently have this:
Code:
SELECT * FROM table1, table2, table3 ORDER BY Command, Description
This works for one table, but with more than one I get the error:

Run-time error 3079
The specified field "Command" could refer to more than one table listed in the FROM clause of your SQL statement.

Thanks for any help.

Daryl