Results 1 to 7 of 7

Thread: SQL select statement (need help)

Threaded View

  1. 03-08-2003, 04:47 PM #1
    JA0822
    JA0822 is offline Registered User
    Join Date
    Mar 2003
    Posts
    9

    SQL select statement (need help)

    I have the following information in a table:

    OBJECT PATHCODE
    --------- ------------


    B75A00094 DV7333
    B75A00094 PY7333
    B75A00095 DV7333
    B75A00095 PY7333
    B75A00096 DV7333
    B75A00096 PY7333
    B75A00096 PD7333
    B75A00097 PD7333
    B75A00097 PY7333
    B75A00097 DV7333

    I need to form a select statment that would only give me the "OBJECT" that do not have the "PATHCODE" value of "PD7333". In this example, I would only want B75A00094 and B75A00095 returned as the results. Any suggestions would be greatly appreciated.
    Last edited by JA0822; 03-08-2003 at 04:50 PM.
    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