>oh that fbobname is a bad variable srry. but u use T can you tell me what T is?

T is the alias (a shortcut) you can use to simplify the query.

Say,

select MyFirstTableName.Field1, myFirstTableName.Field2, MySecondTableName.Field1 from myFirstTableName inner join
mySecondTableName on myFirstTableName.PK = mySecondTableName.FK

is the same as

select T1.Field1, T1.Field2, T2.Field1 from myFirstTableName as T1 inner join
mySecondTableName as T2 on T1.PK = T2.FK

You can give aliases to the tables and also to the fields. If you're using a derived table, then you MUST give it an alias.