Em Andamento

SQL Query for Access 2000

I have two tables in an Access 2000 database with multiple instances of a particular field in each table. I want a single Access 2000 SQL query that will give the total count of occurrences for each distinct appearance of the field from the two tables, have in line SQL queries to give the distinct

totals from the individual tables and want to combine the two into one SQL query to be executed in VB without writing to the database or saving any of the queries to the database. The tables have headings of aor_id and pos_id which are actually the same thing and hence the same data type. No changes

can be made to the structure of the tables. No queries can be saved on the database. Ideal solution would be inline SQL query. second prize would be to create queries temporarily in Access and then delete the queries after using them but this is far from optimal. I can provide the queries already there

and the tables populated with sample data. The two queries I have are basically the same with table name only changed. SELECT DISTINCT b1.AOR_ID,

(SELECT count (b2.AOR_ID) from BS_FREQ_REQ b2 where b2.AOR_ID=b1.AOR_ID) AS

Total

FROM BS_FREQ_REQ AS b1;. How to combine the two to give one query is the issue.

## Deliverables

1) Complete and fully-functional query text 2) Access 2000 MDB with short, sample data on tables and query saved to demonstrate successful processing 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Access 2000, Windows

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

Ver mais: tables data structure, n query, data structure solution, writing sql queries, short work, structure engineering, sql query, sql queries, query table, data query, b2, access 2000 database, access delete, access multiple text, access query table, php sql 2000, sql mdb, changes data access, access table query, sql select, access create query, text sql, queries sql, want 2000, access sql query

Acerca do Empregador:
( 10 comentários ) United Kingdom

ID do Projeto: #2958750

Premiar a:

trishlockhart

See private message.

$21.25 USD em 14 dias
(2 Avaliações)
0.7

21 freelancers estão ofertando em média $14 para este trabalho

Prashantskin

See private message.

$12.75 USD in 14 dias
(528 Comentários)
7.1
TakeRealUK

See private message.

$12.75 USD in 14 dias
(552 Comentários)
6.7
harisraheem

See private message.

$8.5 USD in 14 dias
(23 Comentários)
6.1
tobsvw

See private message.

$21.25 USD in 14 dias
(67 Comentários)
6.0
sawamu

See private message.

$12.75 USD in 14 dias
(215 Comentários)
5.9
pursca

See private message.

$5.1 USD in 14 dias
(30 Comentários)
5.2
miguelgarcia78

See private message.

$12.75 USD in 14 dias
(79 Comentários)
5.2
bukhtik

See private message.

$21.25 USD in 14 dias
(22 Comentários)
5.1
prasanna123

See private message.

$8.5 USD in 14 dias
(58 Comentários)
5.1
timk98

See private message.

$12.75 USD in 14 dias
(54 Comentários)
4.7
zolly

See private message.

$8.5 USD in 14 dias
(19 Comentários)
4.6
brantk

See private message.

$6.8 USD in 14 dias
(35 Comentários)
4.2
dalsim

See private message.

$6.8 USD in 14 dias
(3 Comentários)
4.1
RuAnSoft

See private message.

$17 USD in 14 dias
(3 Comentários)
3.6
vasomecola

See private message.

$10.2 USD in 14 dias
(18 Comentários)
2.5
mjdprogramming

See private message.

$21.25 USD in 14 dias
(0 Comentários)
0.0
mordecaivw

See private message.

$20.83 USD in 14 dias
(0 Comentários)
0.0
codesharkvw

See private message.

$21.25 USD in 14 dias
(0 Comentários)
0.0
wbspring

See private message.

$6.8 USD in 14 dias
(0 Comentários)
0.0
vw906100vw

See private message.

$17 USD in 14 dias
(0 Comentários)
0.0