В роботі

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

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

Показати більше: display decimal points sql select statement, typing sql select statement, write sql select statement increase salary, sql select random repeat, oracle sql select column lable, firebird sql javascript, sql select last entry, autoit firebird sql

Про роботодавця:
( 23 відгуки(-ів) ) Roanoke, United States

ID проекту: #8048264

Доручено:

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 за 1 день
(26 відгуків(-и))
5.5

5 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $27

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 Більше

$35 USD за 1 день
(18 відгуків(-и))
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 за 1 день
(5 відгуків(-и))
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 Більше

$23 USD за 1 день
(3 відгуків(-и))
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 Більше

$25 USD за 1 день
(0 відгуків(-и))
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 за 1 день
(0 відгуків(-и))
0.0