Welcome Guest, Not a member yet? Register   Sign In
SQL select from two tables loop
#1

[eluser]Unknown[/eluser]
Hello,
I am having trouble with pulling out some data from two tables.
The logic is to pull out all users and firm names that are added for that user.
It should show the results like this:

User1
-firm1
-firm2
-firm3

User2
-no firms added

User3
-firm1
-firm2

Hope you understand me, the key is showing all users with the firms added.
I tried with join but then it doesn't show the users which haven't added firm.
Thank you!
#2

[eluser]Nick_MyShuitings[/eluser]
Left Join, not Inner Join... problem solved.




Theme © iAndrew 2016 - Forum software by © MyBB