One of the users has tables set up as


MoveWork
--------------
AcctName
MoveFromID
MoveToID

MoveFromID and MoveToID are keys into this table

Regions
----------
RegID
RegName

He wants to create a query for all accounts showing region names for move from, and move to.

Eg

Acct1 RegionA RegionB
Acct2 RegionQ RegionZ

I figured with that layout his only option was to include the regions table twice in the query, something like

select m.acctname, ra.regname, rb.regname
from movework m, regions ra, regions rb
where m.movefromid = ra.regid and m.movetoid = rb.regid

But something is itching me and I think there's a better way to do it but I can't come up with it. If there's not a better way with that layout, is there a better way to organize it?