I have a query
select U_Acc from [@Gen_Details]
This query will return 2-3 title accounts, Now i need all the child accounts of the Result.
select AcctCode from OACT where OACT.AcctCode LIKE (select U_Acc from [@Gen_Details])+'%'
This query result in ERROR. Is there any possible way for the.
PS: This query is only a part of a big query with two Union all