Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    103

    Unanswered: data query problem

    Hi all
    I wish to make a query of data which from basically 2 tables

    table A:
    staffName
    jobName
    skillType (value is either 'C' or 'A')

    tableB
    staffName
    jobName

    i want to take all the record in table A where, staffName and jobName must exist in table B, i tried using outer join, but i only be able to link either staffName or jobName but not both.

    how can i do that? i hope i explain the problem clearly, but feel free to ask me about it, if anything i didnt state.

    Thanks in advance

  2. #2
    Join Date
    Jun 2006
    Posts
    103
    Hi all,

    I have found a way to do it. thanks.

Posting Permissions

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