Forum Discussion
Left outer Join - but only selected columns from both tables
Hi - I feel this should be easy but I can't work it out. I have table A - it has let's say 50 columns, it's quite big. I have table B - let's say it also has 50 columns. I need to merge thes...
Thanks Poojara. My issue is not the above - I know how to do that - but the fact that down the track I will need to use all the columns in Table A (the left table) so I cant delete them from the merge.
I could make a copy of the table, but that impacts performance as it hits the DB twice and has millions of rows.