# How to make this query run faster

Hello,

Please help simplify the below query to run faster.

select

B.T$orno,

E.T$mitm,

C.T$dsca,

C.T$citg,

A.T$prlc(1),

A.T$prmc(1),

A.T$proc(1),

D.T$dsca,

E.T$cwar,

B.T$tano

from

baan.tbptmm200710 A,

baan.tbptmm220710 B,

baan.ttcibd001710 C,

baan.ttcmcs062710 D,

baan.ttisfc001710 E

where

B.T$orno >= B.T$orno.f and

B.T$orno <= B.T$orno.t and

E.T$mitm >= E.T$mitm.f and

E.T$mitm <= E.T$mitm.t and

C.T$citg >= C.T$citg.f and

C.T$citg <= C.T$citg.t and

B.T$trdt >= B.T$trdt.f and

B.T$trdt <= B.T$trdt.t and

C.T$cpcl >= C.T$cpcl.f and

C.T$cpcl <= C.T$cpcl.t and

B.T$orno = E.T$pdno and

B.T$psqn = A.T$psqn and

B.T$trdt = A.T$trdt and

C.T$cpcl = D.T$cpcl and

E.T$mitm = C.T$item

order by

B.t$orno;

Please Help!

Thanks in advance

For more details check http://blog.advids.co/12-b2b-video-production-tips-to-drive-more-engagement

# Keyboard shortcuts

### Generic

? | Show this help |
---|---|

ESC | Blurs the current field |

### Comment Form

r | Focus the comment reply box |
---|---|

^ + ↩ | Submit the comment |

You can use `Command ⌘`

instead of `Control ^`

on Mac