Skip to Content
Former Member
May 13, 2010 at 01:56 AM

Help with basic query report


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