SQL code

Page 1 of 1
3 posts
SQL code

rpbeesley
New MMEX User

Posts: 1
Joined: Wed Aug 01, 2018 8:19 am
Hi. I'm new to SQL, and completely lost in trying to get what I want. Is anyone able to point me in the right direction, please?

I have a single account, which has income (donations) from a number of payees, and expenditure (grant payments) to one recipient (payee). What I would like is the similar to the built-in Payee report, but to only show payees where the TRANSCODE is Deposit.

I've managed to use a sample SQL report to get a list of the transactions, but cannot see how to exclude a specific TRANSCODE, and no idea how to get the chart (or use dates selected by the user).

SQL in use at the moment is as follows. Any help very gratefully received.


select PAYEENAME,CATEGNAME,TRANSCODE,TRANSAMOUNT
from
CHECKINGACCOUNT_V1
join
ACCOUNTLIST_V1 on CHECKINGACCOUNT_V1.ACCOUNTID=ACCOUNTLIST_V1.ACCOUNTID
join
PAYEE_V1 on PAYEE_V1.PAYEEID=CHECKINGACCOUNT_V1.PAYEEID
join
CATEGORY_V1 on CATEGORY_V1.CATEGID=CHECKINGACCOUNT_V1.CATEGID;
Re: SQL code

siowena
Super MMEX User

Posts: 20
Joined: Tue Jul 17, 2018 2:04 am
rpbeesley wrote:Hi. I'm new to SQL, and completely lost in trying to get what I want. Is anyone able to point me in the right direction, please?...


Did you get this sorted?

You need the WHERE clause.

---
select PAYEENAME,CATEGNAME,TRANSCODE,TRANSAMOUNT
from CHECKINGACCOUNT_V1
join ACCOUNTLIST_V1 on CHECKINGACCOUNT_V1.ACCOUNTID=ACCOUNTLIST_V1.ACCOUNTID
join PAYEE_V1 on PAYEE_V1.PAYEEID=CHECKINGACCOUNT_V1.PAYEEID
join CATEGORY_V1 on CATEGORY_V1.CATEGID=CHECKINGACCOUNT_V1.CATEGID
where CHECKINGACCOUNT_V1.TRANSCODE = 'Deposit';
Re: SQL code

ShehrozQasim
New MMEX User

Posts: 1
Joined: Fri Mar 22, 2019 1:32 am
Hey Dear, I don't know what do you like to get a service or not. But if you have a budget to solve this problem then I will recommend a WebExperts. They are the No.1 ecommerce website development company in Karachi. I am sure you get to solve your question from them, but don't worry if you don't have a budget to get work from them. Go to StackOverflow and search the question you have. Might be someone has listed this question before and have gotten a solution from there.
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests