ArriBen
Epic Member
- Joined
- Sep 18, 2015
- Messages
- 1,064
- Reaction score
- 174
- Points
- 3,485
Morning,
Wondering if someone can help me here, I am not a SQL developer and am learning as I go.
I wrote a query which appears to be working, however it also appears to be looping itself as shown in the screenshot.
I suspect this has something to do with the join I am using for the order recipe as it works fine if I take it out.
The recipe is on a different table to the orders one and am struggling to understand where I am going wrong - I know that you need need to have a common field between 2 tables to create a join, so where am I going wrong?
Thanks!
Wondering if someone can help me here, I am not a SQL developer and am learning as I go.
I wrote a query which appears to be working, however it also appears to be looping itself as shown in the screenshot.
I suspect this has something to do with the join I am using for the order recipe as it works fine if I take it out.
The recipe is on a different table to the orders one and am struggling to understand where I am going wrong - I know that you need need to have a common field between 2 tables to create a join, so where am I going wrong?
Thanks!