Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax help
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
01416815
Message ID:
01416821
Views:
42
Thank you for your suggestion. I was expecting only 1 row as a return from those 2 subqueries. The problem ended up being a typo...in a DSPQOH I reference incorrect table alias:
...where ItemMst.EDPNo = ItemMst.EDPNo
it should have been
where itm.EDPNo = ItemMst.EDPNo
DAniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform