I'm joining table A - always present with table B - not always present - in a query that returns some columns from A and one column from B- let's called it bcolumn.
I'd like bcolumn to contain the value from table B with there is a row in table B and spaces if there is no row in table B, rather than nulls.
I've hit a creative wall today.
Help!
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.