Hello Everyone,
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 johnreeves231@gmail.com.
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,
John Reeves
*This post is locked for comments
Try the following and please let me know your concerns
select firstname,lastname,accountnumber
from customer inner join [transaction] on customer.id=customerid
inner join transactionentry on [transaction].transactionnumber=transactionentry.transactionnumber
and [transaction].storeid=transactionentry.storeid
inner join item on item.id=itemid
where itemlookupcode in ('ggg','fff','ddd')
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156