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...
If possible, finish joins operation at the RDB side (SQL Server, MySQL, Oracle ...); not only because those "traditional RDB" are more performant in joining, but what's more practical is that they support flexible Non-equi joins.
If all you can do is only PQ, try Tables.SelectColumns() to choose necessary columns; then join the resultant tables.
Thanks. It's a good point. I do need to do more dev pre PQ. 😛
