jeffwest21
IS-IT--Management
Having a stupid moment that I hope someone can help me with.
I have a number of tables to pull some data from, two tables in particular, one has an ID that may or may not appear in table 2, the tables are linked via a join where a.con_id = b.Con_id.
How do or I set up my join to pull back data for both those records where it does not exist and where they do, I am sure I have done this before, but as I am trying to update someone else's code, I am trying to not to try and have to rewrite the entire very long winded SP to achieve this.
'Clever boy...'
I have a number of tables to pull some data from, two tables in particular, one has an ID that may or may not appear in table 2, the tables are linked via a join where a.con_id = b.Con_id.
How do or I set up my join to pull back data for both those records where it does not exist and where they do, I am sure I have done this before, but as I am trying to update someone else's code, I am trying to not to try and have to rewrite the entire very long winded SP to achieve this.
'Clever boy...'