Help with basic query report

[Former Member]

Hello all

I have been lumped with trying to nut this out but not having any experience with B1 am having an issue with a User Query that I hope someone can help with..

Below it the query we currently have, however I would like to add the customers ship to address to this query report.

Thanks in advance

SELECT T0.CardCode, T0.CardType, T0.CardName, T0.CntctPrsn, T0.Block, T0.City, ZipCode, T0.State1, T0.Phone1, T0.Cellular, T0.Balance, T0.SlpCode, T0.Territory FROM OCRD T0

[Former Member]

Hello,

You may try this:

SELECT T0.CardCode, T0.CardType, T0.CardName, T0.CntctPrsn, T0.Block, T0.City, ZipCode, T0.State1, T0.Phone1, T0.Cellular, T0.Balance, T0.SlpCode, T0.Territory, T0.MailAddres,

T0.MailBlock, T0.MailCity, T0.MailZipCod, T0.State2

FROM dbo.OCRD T0

Thanks,

Gordon

[Former Member]

thanks mate...

In the end I managed to nut it out myself by searching around on the forum looking at our query requests..

but thank you for your response..