Help with SQL in MS Access
-
Hello ! I'm doing little project and I need database for it, but not whole server. So I choose Access ... But that's pain in the a** :( I have a relatively simply query in which I need to do LEFT JOIN: SELECT a.*, b.* FROM a LEFT JOIN b ON (a.pid = b.pretplatnik_id) AND (a.iid = b.izdanje_id); a and b are booth some other queries. I needed to do this because I can't do query inside a query in access :( And there's problem. It all works, except it shows only data from query a and nothing from query b. Everything from b is NULL. Interesting thing is that if I change part "LEFT JOIN" to "INNER JOIN" it returns booth results from query a and b. So does anyone have an idea why LEFT JOIN isn't working ? Thanks for your time and help :)
-
Hello ! I'm doing little project and I need database for it, but not whole server. So I choose Access ... But that's pain in the a** :( I have a relatively simply query in which I need to do LEFT JOIN: SELECT a.*, b.* FROM a LEFT JOIN b ON (a.pid = b.pretplatnik_id) AND (a.iid = b.izdanje_id); a and b are booth some other queries. I needed to do this because I can't do query inside a query in access :( And there's problem. It all works, except it shows only data from query a and nothing from query b. Everything from b is NULL. Interesting thing is that if I change part "LEFT JOIN" to "INNER JOIN" it returns booth results from query a and b. So does anyone have an idea why LEFT JOIN isn't working ? Thanks for your time and help :)
-
try to use
LEFT OUTER JOIN
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
-
Well,if you don't mind then post here some tables data, and result which you want to get and we will try to give you hand on query. :)
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
-
Well,if you don't mind then post here some tables data, and result which you want to get and we will try to give you hand on query. :)
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
Thanks, but I've solved it :D In b query I've had GROUP BY statement, and it was something like SELECT blabla FROM bla GROUP BY pid, iid; Now I've changed it to SELECT blabla FROM bla GROUP BY iid, pid; and everything works ... Although I don't think there's any difference, but ok ... if there is, please explain it to me :D
-
Thanks, but I've solved it :D In b query I've had GROUP BY statement, and it was something like SELECT blabla FROM bla GROUP BY pid, iid; Now I've changed it to SELECT blabla FROM bla GROUP BY iid, pid; and everything works ... Although I don't think there's any difference, but ok ... if there is, please explain it to me :D
-
It's possible to use DISTINCT instead of GROUP BY but when you had solution then let it as it is.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
-
Yes, but can I use distinct with two fields ? And I also did use SUM with GROUP, I think that I can't use sum with distinct ...
When you have case to use agregate functions then better use GROUP BY but still you can use DISTINC and with subquery you can get SUM or any else agregate function.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
-
When you have case to use agregate functions then better use GROUP BY but still you can use DISTINC and with subquery you can get SUM or any else agregate function.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.