>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.
If it's not broken, fix it until it is.
My Blog