Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011

    Unanswered: Question Regarding Join and conditional clause

    I have two tables, for example

    Table A
    Column 1(primary key)
    Column 2
    Column 3

    Table B
    Column 4 (primary key)
    Column 5 (foreign key based on Column 1 of Table A)
    Column 6
    Column 7

    I only want rows from Table B that do not correspond to rows in Table A but with an exception. I would like to include rows from Table B that have corresponding rows in Table A if Column 7 is populated with a value other than "failed". I would appreciate if someone can help me with this problem. I tried using left outer join but could not get the results. Thanks.

  2. #2
    Join Date
    Jun 2007
    Is this the whole coursework or was there any extra information?
    When does the work need to be done by?

Posting Permissions

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