HELP IN DATABASE

[wuliao23]

HI,
NEED HELP IN CREATING DATABASE...
HOW TO DEVELOP A PROGRAM THAT WILL WRITE DATA IN THE TABLE1 AND TABLE2 (SHOW IN THE ATTACHMENT) DIFFERENTLY IN DATABASE?
ANOTHER QUESTION IS HOW TO CREATE THE PROGRAM THAT USING DATABASE TO TAKE THE VALUE FROM THE TABLE1 AND TABLE2 FOR {A}, {B}, {D}, {E} BY THIS CONDITION...(WHEN VALUE FOR {C}=VALUE FOR {F} )??
SUCH AS IN THE ATTACHMENT, COLUMN 3 IN THE TABLE1, VALUE {C} IS 7 AND THE SAME VALUE FOR {F} IN TABLE2 IS ALSO AT COLUMN 3 FROM TABLE2....SO, I NEED TO TAKE THE READING IN THE COLUMN 3 FOR {A}, {B} FROM TABLE1 AND {D}, {E} FROM TABLE2...
ANYONE HELP??
THANKS FOR HELP...

[Devin_K]

wuliao23,

The Database Connectivity Toolkit can be used to connect to a database and interact with it using built-in functions or SQL.  This toolkit can connect to many popular databases, including Oracle, dBase, Microsoft Access, and Microsoft SQL server.

Using this toolkit you will be able to create tables in the database (your first question) and perform queries using SQL to retrieve sets of data (your second question).  If you are unfamiliar with using SQL, I have found the following page to be very useful for learning the basics you need to get started:
SQL Tutorial

[smercurio_fc]

If you don't want to spend the $1000 for the Database Connectivity Toolkit, there's always the free LabSQL.