Hey all, I'm looking for a way to insert values from one table from another in a pretty straightforward way, I just can't get the syntax...
If table 1 has fields A,B, and C, and table 2 has 20 fields... I want to insert into:
A a value that I choose
B a value selected from one field from table 2 via a select statement
C another value that I choose
How to do it??