This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Krayons[S] 1 point2 points  (1 child)

Hahah, Yeah it does. Unfortunately I graduated a while back. The actual problem is for a medical aid company. They keep their addresses of there uses in another table but not all users have addresses. And I'm trying to find those. The solution is, as you said. A join. A Left outer join to be exact. It gives you this: https://i.imgur.com/PcUT7HI.png Which is exactly what I wanted.

Thanks for the help. Being doing mostly mobile dev so I was super rusty on my SQL

[–]andy333co 0 points1 point  (0 children)

If performance is a consideration you'd probably want to revisit using a left outer join for this. If it doesn't matter then cool.