Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Unanswered: joining fields from 2 tables

    Hi to all,

    i have a table(SubjectAreas) with column staffID which is a foreign key from Staff table.What i need is to Select the staffID's from SubjectArea which i'm ok with but then i need to get the name and surname of those staffID's from Staff table?tnx to all

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi
    Please post the SQL you have created so far and I'll guide you through getting what you want
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2010
    Posts
    2

    [B]SQL joining fields from tables[/B]

    Thanks for the help anyway but i found a method then..

Posting Permissions

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