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[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 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


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

Veja mais: what is the problem statement, what is problem statement, what is a problem statement example, what is a problem statement, what is an example of a problem statement, statement problem example, statement problem, statement of the problem sample, statement of the problem examples, statement of the problem example, statement of problem sample, statement of a problem, sample problem statement, sample of problem statement, purpose of use case, problem statement sample, problem statement examples, problem statement example, problem statement, parts of a problem statement

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

ID do Projeto: #2968620

Concedido a:


See private message.

$7 USD em 1 dia
(480 Comentários)

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


See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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