cancel
Showing results for 
Search instead for 
Did you mean: 

Need a query help

Former Member
0 Kudos

Hi All

Is this possible to create one filed from multiple field ?

Like I need address of business partner on invoice from CRD1

but in crd 1 all address save in seprate fields .

i need those fields in one field on oinv

SELECT T0.[Address]+ T0.[Building]+ T0.[Block]+ T0.[StreetNo]+ T0.[Street]+T0.[City]+

T0.[ZipCode]+ T0.[State]  as'Address'   FROM CRD1 T0​

Accepted Solutions (1)

Accepted Solutions (1)

former_member183582
Active Participant
0 Kudos

Hi ricky 1

You should take all these fields with concatenate function in query.

Regards,

Irfan ullah Irfee

Former Member
0 Kudos

Hi Ullah

Can you please make it for me as I am not much strong in query

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ricky ,

Please use this Query .

SELECT distinct isnull(T0.[Address],'')+ convert(varchar(max),isnull(T0.Building,''))+ isnull(T0.[Block],'')+ isnull(T0.[StreetNo],'')+ isnull(T0.[Street],'')+isnull(T0.[City],'')+

isnull(T0.[ZipCode],'')+ isnull(T0.[State],'')  as'Address'   FROM CRD1 T0​ inner join Oinv T1 on T1.CardCode =T0.cardCode and  T0.Address=T1.Paytocode and

T0.AdresType = 'B'

Thanks

Dhiraj

Former Member
0 Kudos

HI Ricky ,

Please Use this Query .

SELECT isnull(T0.[Address],'')+ convert(varchar(max),isnull(T0.Building,''))+ isnull(T0.[Block],'')+ isnull(T0.[StreetNo],'')+ isnull(T0.[Street],'')+isnull(T0.[City],'')+

isnull(T0.[ZipCode],'')+ isnull(T0.[State],'')  as'Address'   FROM CRD1 T0​

Thanks

Dhiraj

Former Member
0 Kudos

Hi Dhiraj

Thanks for reply , ok tell me one thing , I need to use the filed on crystal so should make join with OCRD and OINV in this query ?