Forum Discussion
bhaskarpbi99
Oct 02, 2024Copper Contributor
Need assistance on SQL server query
Hi All, I have a account table which has parent acct number, Customer name, Account number. the issue is 1 parent account number should have only one customer name even though account number i...
rodgerkong
Oct 03, 2024Iron Contributor
In result B, you have give a column alias cust_name to the function MIN. So when you referring it, you must use cust_name instead of Customer Name. bhaskarpbi99
bhaskarpbi99
Oct 03, 2024Copper Contributor
Hi @rodgerong,
The query is working now . thanks for your valubale support and assistance.
Kudos to you for the solution.
The query is working now . thanks for your valubale support and assistance.
Kudos to you for the solution.