Skip to Content
Jul 09, 2014 at 07:40 AM

Use like and in together in sql



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