SQL Query

[ArriBen]

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!

 

[Ho3n3r]

Could you perhaps post the setup of each table - i.e. the fields, also showing their primary/foreign keys?

Like this:

 

[akafaar]

Hey bud.

Cheers,
Agmad

 

[ArriBen]

Thanks for the replies, I have spoken to one of our SQL staff who will help me later.
Hope you understand but I don't want to post too many shots of work related stuff due to confidentiality etc.

 

[toy1985]

Hey bud.

View attachment 47550

Cheers,
Agmad

This ^


Sent from my iPhone using Tapatalk

 

[Shwam]

Hey bud.

View attachment 47550

Cheers,
Agmad

well there's your problem