Change firebird sql select statement to return rows for unique entries only
$10-30 USD
Paid on delivery
We are using Firebird SQL version2.1
I have an sql query statement as follows:
SELECT [url removed, login to view], [url removed, login to view], [url removed, login to view]
, [url removed, login to view] || ' ' || [url removed, login to view] as owner
, [url removed, login to view] || ' ' || [url removed, login to view] cashier, [url removed, login to view]
, [url removed, login to view]
FROM Checks c
INNER JOIN employee o ON [url removed, login to view] = [url removed, login to view]
INNER JOIN employee ca ON [url removed, login to view] = [url removed, login to view]
LEFT OUTER JOIN checkpayment cp ON [url removed, login to view] = [url removed, login to view]
LEFT OUTER JOIN account a ON [url removed, login to view] = [url removed, login to view]
WHERE [url removed, login to view] = '[url removed, login to view]' and [url removed, login to view] <> 0
ORDER BY printchecknumber ASC
We only want results returned where the value [url removed, login to view] appears only ONCE. Please see attachments for more info.
Project ID: #8048264
About the project
Awarded to:
I'm an SQL / Firebird expert and can do this and deliver to you in a few hours. To start I will need the database with these tables and sample data. Thanks for considering me. Bests, Larry
5 freelancers are bidding on average $27 for this job
I am a database administrator. I am also a freelance database worker. I have a lot of experience with databases especially sql. I think I can help you with your project.
It seems that you have 2 'checkpayment's for that checknumber. You can very easy bring the accountname from a subselect (without the join) or rethink what you are trying to do and do it correctly accordingly