SQL Basics
 

 

You can update as many fields as you want by separating each with a comma, as in the following:

UPDATE PRODUCTION
SET CUSTOMER TO NULL, SLIPID TO NULL, STATUS=0
WHERE SLIPID="17753"

There are also commands to insert new records and remove records. This is a basic introduction to SQL. There are many more features that haven’t been discussed, including joining tables by selecting from more than one table, embedding select statements, searching for partial matches, etc. If you are interested, consult a book on SQL.

                                     

                                                      Phone: (506) 857-0909
                                                        Fax: (506) 858-9271
                                                  Email: advatek@nbnet.nb.ca