mandavli, can you tell me more about how you would do if null and assign a default value? That is what I am looking to do.

If I use a full join wouldn't I lose my opportunities that have no employees? That is what I am trying to avoid.