Results 1 to 6 of 6

Thread: SQL Not Equal Query [Resolved By memnoch and apps_tech]

Threaded View

  1. Jun 10th, 2003, 04:38 PM #1
    Danial
    Danial is offline

    Thread Starter
    Big D Danial's Avatar
    Join Date
    Jul 2000
    Location
    ASP.Net Forum
    Posts
    2,877

    SQL Not Equal Query [Resolved By memnoch and apps_tech]

    Hi,
    I need a sql query but dont know how to write it. I have two table one called Staff and other Contracted_Staff. Now who ever is assigned a contract the StaffId is entered into Contracted_Staff Table, so that way i know which staff is assigned to what contract.

    Now on the new contract section i want to select all the Staff from the table Staff who has not been assigned to any contract (available staff in other words). I want to exclude all the Staff who are in Contracted_Staff table. Now i do i go about writing that query.

    Thanks for your help.

    Danial

    PS: Sorry for posting this in General VB, but i really need the answer urgently.
    Last edited by Danial; Jun 10th, 2003 at 05:04 PM.
    [VBF RSS Feed]

    There is a great war coming. Are you sure you are on the right side? Atleast I have chosen a side.

    If I have been helpful, Please Rate my Post. Thanks.

    This post was powered by :
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width