Change firebird sql select statement to return rows for unique entries only

Completed Posted Jul 11, 2015 Paid on delivery
Completed 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.

SQL

Project ID: #8048264

About the project

5 proposals Remote project Active Jul 11, 2015

Awarded to:

expertcoder1vw

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

$24 USD in 1 day
(26 Reviews)
5.5

5 freelancers are bidding on average $27 for this job

manhpham

Hello, I am interested in your project. I have been working on this site for more than 4 years with many successful and interesting projects. You can see previous comments from my p More

$35 USD in 1 day
(18 Reviews)
4.7
sarahAsher0803

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.

$25 USD in 1 day
(5 Reviews)
3.0
ref2

Hi I have 15+ years of experience in developing application based on database. Currently i support 2 application (for HR) based on firebird database. I have bachelor degre in IT, an certificate for web development More

$23 USD in 1 day
(3 Reviews)
1.7
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using More

$25 USD in 1 day
(0 Reviews)
0.0
sotircamihai

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

$25 USD in 1 day
(0 Reviews)
0.0