Em Andamento

Need access queries converted to mysql

I have an access database and I have most of it converted to mysql but I have a few of the access queries not are not converting over properly. Performance if can be improved also good.

Query1: (test1)

SELECT [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] AS RID, [url removed, login to view] AS SID, [url removed, login to view]

FROM ((Orders INNER JOIN OrderLineItems ON [url removed, login to view] = [url removed, login to view]) LEFT JOIN People ON [url removed, login to view] = [url removed, login to view]) INNER JOIN People AS People_1 ON [url removed, login to view] = [url removed, login to view]

WHERE ((([url removed, login to view])=1) AND (([url removed, login to view])=1));

Query2: (test2)

SELECT DISTINCT [url removed, login to view] AS SID, [url removed, login to view] AS SenderHusband, [url removed, login to view] AS SenderWife, [url removed, login to view] AS SenderLast, [url removed, login to view] AS RID, [url removed, login to view] AS RCVHusband, [url removed, login to view] AS RcvWife, [url removed, login to view] AS RcvLast, [SID] & [RID] AS SENTKEY

FROM Test1 INNER JOIN Test1 AS Test1_1 ON [url removed, login to view] = [url removed, login to view]

WHERE ((([url removed, login to view])=1));

Query3: (Reciprocating)

SELECT Test2.*

FROM Test2

WHERE sentkey not in

(select * from key);

Query4: (DeliveryList)

SELECT [url removed, login to view] AS SHusband, [url removed, login to view] AS SWife, [url removed, login to view] AS SLast, [url removed, login to view] AS STitle, [url removed, login to view] AS SStreetNumber, [url removed, login to view] AS SStreet, [url removed, login to view] AS SCity, [url removed, login to view] AS SState, [url removed, login to view] AS SZipcode, [url removed, login to view] AS RHusband, [url removed, login to view] AS RWife, [url removed, login to view] AS RLast, [url removed, login to view] AS RTitle, [url removed, login to view] AS RStreetNumber, [url removed, login to view] AS RStreet, [url removed, login to view] AS RCity, [url removed, login to view] AS RState, [url removed, login to view] AS RZipcode, [url removed, login to view] AS SID, [url removed, login to view] AS RID

FROM People INNER JOIN (People AS People_1 INNER JOIN OrderLineItems ON [url removed, login to view] = [url removed, login to view]) ON [url removed, login to view] = [url removed, login to view];

The main issue here is that in access I am using table aliass of the same table and since I have an alias I am also using same fields

Habilidades: Engenharia, Microsoft, MySQL, Gestão de projetos, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: mysql city state database, queries, project management access, need improved, database queries, mysql join table, mysql table join, converted mysql, access orders management database, queries database, table queries, converting access project, mysql converted, mysql join, state city mysql, mysql database orders, mysql queries using, access database project management, state database mysql, state city mysql table, city state database mysql, good access, need access database, mysql left, access project management

Acerca do Empregador:
( 66 comentários ) United States

ID do Projeto: #3011499

Premiar a:

randi3001

See private message.

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

18 freelancers estão ofertando em média $81 para este trabalho

hwanghendra

See private message.

$85 USD em 1 dia
(422 Comentários)
6.8
witscomputing

See private message.

$85 USD em 1 dia
(384 Comentários)
6.8
stevebryant

See private message.

$85 USD em 1 dia
(452 Comentários)
6.6
gkalish

See private message.

$85 USD em 1 dia
(245 Comentários)
6.3
vw1621783vw

See private message.

$85 USD em 1 dia
(183 Comentários)
6.0
SonITvWorker

See private message.

$85 USD em 1 dia
(139 Comentários)
5.8
solosofttech

See private message.

$85 USD em 1 dia
(41 Comentários)
5.2
ceePlus

See private message.

$85 USD em 1 dia
(45 Comentários)
5.0
pafkavw

See private message.

$85 USD em 1 dia
(56 Comentários)
4.7
bachchuju

See private message.

$85 USD em 1 dia
(19 Comentários)
4.2
NXTSolutions

See private message.

$85 USD em 1 dia
(12 Comentários)
3.7
abid861

See private message.

$85 USD em 1 dia
(17 Comentários)
3.5
ieinfotech

See private message.

$85 USD em 1 dia
(15 Comentários)
3.3
shouket

See private message.

$85 USD em 1 dia
(10 Comentários)
2.9
basepoint

See private message.

$85 USD em 1 dia
(7 Comentários)
1.4
sivasangaribe

See private message.

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

See private message.

$85 USD em 1 dia
(3 Comentários)
0.0