Unanswered: Question Regarding Join and conditional clause
I have two tables, for example
Column 1(primary key)
Column 4 (primary key)
Column 5 (foreign key based on Column 1 of Table A)
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.