I have two tables - I want to be able to select data from tbl1 and insert it into tbl2. Now here's the deal - Tbl1 has roughly about 30 fields. There are three columns in that table that are not in tbl2. Instead of specifying each field individually, i was trying to see if there's any possible way from me to do something like this...
Insert into Tbl2 SELECT * (but three fields) from tbl1 where value='value'
Insert Into tbl2 SELECT Field1, Field2
This cannot be done, there is no syntax to insert or select 'all fields except'.
And if there were it would be a bad idea to use it, for exactly the same reason that
select * in application code is a bad idea. (Assuming the table definition(s) will never change and that you always need all the data.)