Encerrado

SQL Statement needed URGENT

SELECT [url removed, login to view], SUM([url removed, login to view]) AS totalstocked, SUM([url removed, login to view]) AS totalsold

FROM bw_pricing INNER JOIN

bw_registers ON [url removed, login to view] = [url removed, login to view]

WHERE ([url removed, login to view] IN ('082543050x', '0736902295', '0801091357', '0883685671', '0764222910'))

GROUP BY [url removed, login to view]

produces the following

isbn totalstocked totalsold

0736902295 9 3

0764222910 12600 14

0801091357 110 18

082543050X 105 3

0883685671 1358 105

It should be producing

isbn totalstocked totalsold

0736902295 9 1

0764222910 900 14

0801091357 55 2

082543050X 35 3

0883685671 194 7

where the heck did i screw this sql stmt? I can't find it

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

sql 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic

Ver mais: t-sql in, t-sql;, sql work needed, php sql 2000, sql run package, sql select select, sql select, visual basic work needed, php isbn, urgent program, sql 2000, urgent install, basic SQL , needed program visual, bid statement work, basic sql code, visual basic sql, statement php, statement form, site php sql, visual form sql, install php sql 2003, visual 900, sql request, sql code bid

Acerca do Empregador:
( 71 comentários ) maryville, United States

ID do Projeto: #2980228

6 freelancers estão ofertando em média $3 para este trabalho

TakeRealUK

See private message.

$3.4 USD em 1 dia
(551 Comentários)
6.7
yenduttjain

See private message.

$3.4 USD em 1 dia
(115 Comentários)
6.6
danvlas

See private message.

$3.4 USD em 1 dia
(74 Comentários)
5.6
venuscompusys

See private message.

$3.4 USD em 1 dia
(21 Comentários)
5.0
felenkavw

See private message.

$3.4 USD em 1 dia
(26 Comentários)
3.4
leofsiegeent

See private message.

$3.4 USD em 1 dia
(1 Comentário)
2.8
oguzozgulvw

See private message.

$3.4 USD em 1 dia
(1 Comentário)
0.0