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

Ukończone Opublikowano Jul 11, 2015 Płatność przy odbiorze

$10-30 USD

Płatność przy odbiorze

Ukończone Płatność przy odbiorze

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

Numer ID Projektu: #8048264

O projekcie

5 ofert Zdalny projekt Aktywny Jul 11, 2015

Chcesz zarobić trochę pieniędzy?

Korzyści z składania ofert na Freelancer.com

Ustaw Swój Budżet i Godziny Pracy
Otrzymaj wynagrodzenie za pracę
Opisz, w jaki sposób wykonasz projekt
Rejestracja i składanie ofert do projektów jest darmowe

Przyznany użytkownikowi:

Zdjęcie profilowe użytkownika expertcoder1vw
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 w 1 dzień
(26 ocen)
5.5

5 freelancerów złożyło ofertę za $27 w tym projekcie

Zdjęcie profilowe użytkownika manhpham
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 Więcej

$35 USD w ciągu 1 dnia
(18 Oceny)
4.7
Zdjęcie profilowe użytkownika sarahAsher0803
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 w ciągu 1 dnia
(5 Oceny)
3.0
Zdjęcie profilowe użytkownika ref2
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 Więcej

$23 USD w ciągu 1 dnia
(3 Oceny)
1.7
Zdjęcie profilowe użytkownika zu02
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 Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
Zdjęcie profilowe użytkownika sotircamihai
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 w ciągu 1 dnia
(0 Oceny)
0.0
Opublikuj projekt taki jak ten