Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Unanswered: Adding fields that are in separate table.

    i have two tables each with the following fields:
    NumberOfAbsences; LastName; MiddleName;FirstName; Studentid; YearNo.

    I want to combine them, adding the NumberOfAbsences fields to each other.

    part of the problem is that not every student is in both tables. so studentid 1 might have 3 absences in the first table but isn't listed at all in the second. in the combined table he should be listed with 3 absences.

    any ideas
    Dave

  2. #2
    Join Date
    Feb 2003
    Location
    ireland
    Posts
    3
    give it up dave, its not gonna work!

  3. #3
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    I think it will work. You'll need a complicated query and I am not the guy for that.

    There is a guy on this forum, who's name escapes me, who is.

    Write another post but put SQL problem as the subject. That'll get all the SQL genius' lokking at your problem.
    J.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •