Em Andamento

SQL Statement Needed.

Enclosed is a sample database. The problem is there is a SQL Statement I cannot get to work right The statement I was trying to make is this

select [url removed, login to view] from inventory a, additionalinfo b where a.id=[url removed, login to view] and min([url removed, login to view])>'1975' and max([url removed, login to view])<'1975' and b.make=10 and a.whatpart=1 group by [url removed, login to view]

In this case, it should select at least one because 1975 is after 1968 which is the minimum of the earliest year possible. Plus 1983 is less then 1985 which is the maximum year possible. However, when I try to use the max or min in the where clause, I get an error. It says a subquery is necessary. I need the statement modified so the min and max functions will work when trying to find what records to show. I don't know if there is still something wrong with the logic or not. The purpose of this is to what parts fit the years of vehicles. In this example, for the inventory item, it fits 68-78 and 79-85. That would also mean if the numbers 66-86 was used, this would still work because part of the years used it fits. However, if the numbers being searched was 64-65, then it nothing would show up. Let me know if you have any questions. The relationships are inventory.id=additionalinfo.newpart. That relates the parts to the years it fits.

## Deliverables

The SQL Statement to find matches for the span of years. Here are a few examples

1. 66-67 for the search

years found

64-65 and 69-70

in this case, nothing would show up because none of the years fit.

2. 65-90

years found

66-88

in this case, it should find the record because 66 to 88 is between the span of years of 65 to 90.

Let me know if you have any further questions. I will need the query that would be needed with SQL Server 7.0 and MS Access.

## Platform

MS Access, SQL Server 7.0

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: statement problem examples, statement problem example, statement problem sample, statement problem, purpose use case, problem statement sample, problem statement examples, problem statement example, parts problem statement, parts inventory database, access parts inventory database, examples problem statement, example inventory database, sample problem statement, problem statement, example problem statement, sql server max, max sql server, sql work needed, access sql, engineering year, sql select, inventory parts access

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

ID do Projeto: #2968620

Premiar a:

gribfritz

See private message.

$7 USD em 1 dia
(480 Avaliações)
7.6

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

TakeRealUK

See private message.

$8.5 USD em 1 dia
(724 Comentários)
6.9
stardust126

See private message.

$4.25 USD em 1 dia
(56 Comentários)
5.2
captainjoe

See private message.

$8.5 USD em 1 dia
(13 Comentários)
3.4
grzegorztwa

See private message.

$17 USD em 1 dia
(3 Comentários)
2.1
indivw

See private message.

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

See private message.

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