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

Concluído Postado Jul 11, 2015 Pago na entrega

$10-30 USD

Pago na entrega

Concluído Pago na entrega

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

ID do Projeto: #8048264

Sobre o projeto

5 propostas Projeto remoto Ativo em Jul 11, 2015

Afim de ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e prazo
Receba pelo seu trabalho
Descreva sua proposta
Cadastre-se e oferte em trabalhos gratuitamente

Concedido a:

Imagem de Perfil de 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 em 1 dia
(26 Comentários)
5.5

5 freelancers estão ofertando em média $27 nesse trabalho

Imagem de Perfil de 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 Mais

$35 USD em 1 dia
(18 Comentários)
4.7
Imagem de Perfil de 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 em 1 dia
(5 Comentários)
3.0
Imagem de Perfil de 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 Mais

$23 USD em 1 dia
(3 Comentários)
1.7
Imagem de Perfil de 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 Mais

$25 USD em 1 dia
(0 Comentários)
0.0
Imagem de Perfil de 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 em 1 dia
(0 Comentários)
0.0
Criar Projeto Similar