sql

  • Thread starter Thread starter Squibbly
  • Start date Start date
S

Squibbly

is it possible to update a table via an sql query, i know how to delete a
record from a table, but b4 i delete the record i want to update a different
table but certain fields are required to in the new table
 
Squibbly,

Most likely, you need to use an Update Query or an Append Query for
this, but at this stage you haven't provided enough information for
anyone to be able to determine which is applicable.
 
what i want to do is put one record into a table, not all fields are
required though,
then i want to delete it. i know how to delete a record in a table using the
DELETE in SQL
but dont know how to move or create a new record in a table that already
exists
 
Squibbly,

Thanks for the further clarification. Ok, it's starting to look like an
Append Query. This involves an INSERT INTO statement in SQL.
 
Back
Top