Em Andamento

SQL Statement to show inventory needed

The place to find the database for the SQL Statement is [url removed, login to view]

There are 4 tables. The relationships between the tables are these:

itemsown.inventory=[url removed, login to view]

itemsold.inventory=[url removed, login to view]

invoices.partnum=[url removed, login to view]

itemsold.invoice=[url removed, login to view]

if an inventory item is in the itemsold table but nothing matching in the itemsown, then show it as null. The statement should return all the sales (count them) from the last 30 days. If nothing corresponds to the itemsown, then show that column as null. Also, from the itemsold, it should only show where shouldhome='y'

The information retrieved should be something like this

Inventory Number, Items Sold, Side, Items Currently Have

For this sample, just show all the ones after 10/07/03. I can change it later to show for the last 30 days.

The inventory number needs to be the [url removed, login to view]

needs to group by [url removed, login to view]

itemsold should count how many sold of the inventory item.

items currently have should either be 0 if the current amount is 0. For the itemsown, no sum function is necessary. It needs to be grouped by side as well. It may or may not be null. The purpose of this is to show based on the 30 day sells, what items needs to be ordered. If there is one with a left and a right, show them twice. Let me know if you have any other questions.

## Deliverables

The SQL Statement to show the sells from the last 30 days. The columns to show are these:

1. Part Number (found on [url removed, login to view])

2. Items Sold

3. Side

4. Items Have In Stock (even show nulls)

Show ones after 10/07/03

Comment on the different parts of the statement.

## Platform

Windows 2000

Habilidades: ASP, Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic, Área de trabalho do Windows

Ver mais: return invoice sample, parts inventory database, statement of purpose, statement for purpose, inventory database, asp sql, sql different, last days sql, php sql 2000, sql stock inventory, sql mdb, stock inventory sql, matching items, inventory part, sql inventory, php database invoice number, sample sales inventory database, stock inventory database, inventory sales database, database sales inventory, windows invoices, sales inventory database, vehicle parts database, sql questions, count inventory

Acerca do Empregador:
( 781 comentários ) Sydney, Australia

ID do Projeto: #3005127

Premiar a:

TakeReal

See private message.

$17 USD em 1 dia
(1326 Avaliações)
7.6

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

unt

See private message.

$8.5 USD em 1 dia
(12 Comentários)
4.0
icodeinc

See private message.

$42.5 USD em 1 dia
(1 Comentário)
0.3
kiduboy

See private message.

$12.75 USD em 1 dia
(1 Comentário)
0.0
blizzyvw

See private message.

$8.5 USD em 1 dia
(0 Comentários)
0.0
troyvwvw

See private message.

$42.5 USD em 1 dia
(0 Comentários)
0.0