[RESOLVED] Composite Table Issues - Does not match table definition

[techgnome]

No, we only have two fields... created and changed by.... but yes, in short, that's what we have... so now let's say I want to pull a record and see who created it and who last edited it... it looks like this:

select 
  T.Id, T.Field1, T.Field3, C.Name as CreatedBy, E.Name as EditedBy
from SomeTable T
inner join *****ers C on T.CreatedByID = C.ID
inner join *****ers E on T.ChangedByID = E.ID

Now I see the data in the record (T) and who created it (C) and who last changed the record (E).


-tg