Forum Discussion
Solved
Add Column Based on Whether Value Exists in Other Table
I have a query called Brand that I want to essentially LEFT OUTER JOIN (if these were SQL tables) to another query called xrefKeyBrand to add one of it's columns (KeyBrandFlag). The xrefKeyBrand is...
Hi,
If I understand your problem correctly, the solution should be easy:
1. Create a Merged Table:2. Use LEFT join (as you can see, only 3 records are matching out of 5)
3.In new Query, expand the second table and use your join column (in my case is Order ID)
4. Create a conditional column, where Order ID == OrderID.1
Let me know if this helps!
This isn't exactly how I accomplished it, but it did get me close enough to do what I was trying to do. I used the merge query. Just not as new query. I didn't want a new query. But thanks for the help!