query result confusion

[swift]

Hi all,
I'm looking for some help with this query problem I'm having. Basically I'm trying to query two tables carrying similar data fields so that the result shows the matching fields together. I've attached an example of what I'm trying to do in xls format as I'm not particularly sure how to describe the problem in Access speak! It would seem pretty straight forward but I seem to be returning multiple results. If anyone can point me in the right direction I would be forever grateful!

(Sorry for the shortness, still at work, boss looking over shoulder).

Cheers

Swifty

 

[Yarp]

I think the problem is because the tables are only joined by the Section_Label, hence for each entry in Table_S, you are getting one line of Table_T at a time. If you join them by 'From' as well, this should resolve your issue. If you are not sure, post the SQL as well and we can advise how to amend it.

Note: If your from is not going to be unique, then you will need to also join by 'To'

P.S. If you post the code, please use a code box.

 

[swift]

Sorry for the delay in replying - Yarp that solved the problem straight away, thanks very much for your assistance!