Node_Table        InputList_Table        InputParameter_Table

NodeID    1 - oo  NodeID                    Input_ID
...               Input_ID         oo - 1     ....
...                ...                        ....

How do I retrieve all InputParameters by a given NodeID?

Robert

Elio

Elio, what did you exactly mean with "(Note, don't use *, type in the
fields...)" and are IL and IP new created objects?

As I guess I have to dig into SQL and unfortunatly bought the wrong
book to begin with (Joe Celko) I had a look at amazon and found:

o - SQL: The Complete Reference (Osborne's
                      Complete Reference Series)  

o - MySQL (OTHER NEW RIDERS)  , Paul DuBois  

o - Database Magic with Ken North  

o - Sams Teach Yourself SQL in 24 Hours, Ryan Stephens, Ronald Plew,
Ronald R. Plew  

o - Advanced ANSI Sql Data Modeling and
                      Structure Processing (Artech House Computer
                      Science Library)  
(awfully expensive!)

I intuitivily intend to Osborn because of having experience with
Schildts C/C++ guide which was easy and understandable to read.

Would somebody recommend another book as a tutorial to get into SQL?

Thanks to Elio and Gary for their quick answers

Robert

Set Dtbs = OpenDatabase(DB)
Set snap = Dtbs.CreateSnapshot("SELECT * FROM Nodes, InputList,
InputParameters WHERE NodeID = " & nd)

Which gave the error "1 parameters expected, 0 recieved", although
debugging showed that nd was a valid integer of "34".

Could you kindly give me a hint?

Robert

what about trying like this
...
 Set snap = Dtbs.CreateSnapshot("SELECT * FROM Nodes, InputList,
 InputParameters WHERE NodeID = " & Cstr(nd))