This is the first time I have posted anything here so I really hope someone can help me. Right now i am trying to build a custom report within "Crystal Reports for Blackbaud" that will pull all the customer names that have bought a specific item or a list of items (Stock Item Number). I don' know SQL very well or else I would be using the Microsoft Retail Management Administrator Query console. Is anyone well-versed enough in this program to help me build this query? You can get back to me either by posting a reply on this thread or e-mailing me personally at firstname.lastname@example.org.
I truly hope someone can help me with this as it is a very important report that I must get completed rather quickly. I just wish I knew the system and database better then I currently do.
Thanks in advance,
Try the following and please let me know your concerns
from customer inner join [transaction] on customer.id=customerid
inner join transactionentry on [transaction].transactionnumber=transactionentry.transactionnumber
inner join item on item.id=itemid
where itemlookupcode in ('ggg','fff','ddd')