Hello,
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.

Is this the whole coursework or was there any extra information?
When does the work need to be done by?