You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a query set up that pulls data from multiple sources. I am checking to see if a part number doesn't have match to something specific but one of the tables can have a null value.
Can I use an IF statement on in INNER JOIN. Here is the line of code I currently have
INNER JOIN up ON up.aexitm_item_nbr = bom.bm_assy_item_nbr AND up.location = bom.location
The up.aexitm_item_nbr table does not always have a match to the bom.bm_assy_item_nbr so I would like to say IF up.aexitm_item_nbr ISNULL then pull from mp.im_item_nbr.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have a query set up that pulls data from multiple sources. I am checking to see if a part number doesn't have match to something specific but one of the tables can have a null value.
Can I use an IF statement on in INNER JOIN. Here is the line of code I currently have
INNER JOIN up ON up.aexitm_item_nbr = bom.bm_assy_item_nbr AND up.location = bom.location
The up.aexitm_item_nbr table does not always have a match to the bom.bm_assy_item_nbr so I would like to say IF up.aexitm_item_nbr ISNULL then pull from mp.im_item_nbr.
Beta Was this translation helpful? Give feedback.
All reactions