Hi Everyone -

Am I glad I found this newsgroup! I'm new to Visual Basic and am trying
to create a small database that would involve two tables. I have a table
with employee info that uses the SSN as the primary key. The second
table contains payroll information and also uses the SSN as the primary
key. I need to link them together so that I can make updates to both, do
cascading deletes, etc. So far, the books I have found don't deal much
with using SQL for VB3 or joining tables so I am throwing myself on your
mercy! Any guidance would be greatly appreciated.

Thanks in advance,

Pete Davini

                       \\\\|||||////
                        \\       //
                         \ ~   ~ /
                       (~  0   0  ~)
  --------------------o000^--V--^000o-----------------------
       Pete Davini                   Heurikon Corporation

            "Some mornings, it's just not worth
             chewing through the leather straps"
                       Emo Phillips    
  ----------------------------------------------------------

Sounds like you might need to include something like this in your 'From'
statement.

From Payroll, Employee, Payroll Left Join Employee on
Payroll.SSN=Employee.SSN....

P.S.

The visual basic help files provide a fair amount of sql help also you
can download the knowledge base from Microsoft download
site (ftp.microsoft.com)

Jim