Query to display in single row

[access]

Hi,

I have two tables
T1
TID | Len
22----2

T2
TID | Len2
22-----3
22-----4

I need a query to display
TID | Len | DiffLen1 | DiffLen2.....|DiffLenn
22----2----1(3-2)-----2(4-2)------....

I'm able to write a query as below:
SELECT T1.TID, T1.Len, T2.Len2-T1.Len FROM T1 INNER JOIN T2 ON T1.TID = T2.TID;

But this display entries as:
TID | Len | DiffLen
22----2----1(3-2)
22----2----2(4-2)


....

How can i change my query to display in a single row Please help me out in this regard. Thanks.

[access]

Can any one please help on this. Thanks in advance

[access]

Please let me know if i'm not clear.

[jbarrum]

Hello,

I think I will be able to help but I am unclear as to what your fields are and what data type that they hold. Can you clarify

[access]

Thanks for your reply.
For table T1
TID, Len are the fields of type Number
also For table T2
TID, Len2 are the fields of type Number

I'm able to write a query as below:
SELECT T1.TID, T1.Len, T2.Len2-T1.Len FROM T1 INNER JOIN T2 ON T1.TID = T2.TID;

But this display entries as:
TID---Len----DiffLen
22-----2-----1(3-2)
22-----2-----2(4-2)

I would like to display it as:
TID---Len---DiffLen1---DiffLen2---DiffLenN
22-----2----1(3-2)-----2(4-2)------....

[jbarrum]

ok, i thnk i understand now. you need to create a releationship between table 1 and tble 1 by linking the field TID. However, I have a concern that you are creating a normalization problem. Why is TID being stored in two differnt tables?

[access]

Thanks for your reply. There tables are pre-existing. So, i havent thought about the design and i'm not supposed to change the design. My task is to just write a query to appear in single row.

[jbarrum]

I understand. Trying ceating the relationship between the two and let me know if that works. You will propably need a outerjoin

[access]

Created a relationship between two tables with TID. But there is no change in the output of the query.

I'm getting some error when i changed from inner join to outer join.

[jbarrum]

you will get an error if you have data in the two tables and that data does not meet the criteria of the inner or outer join(whichever one you are trying to do). If you do not get the error then the data meets the criteria of the join.

[jbarrum]

if the tables only have test data, then delete the data, create the joine and then re-enter the data and try your query.