Database

SELECT
    CASE a.TType
        WHEN 'E' THEN b.field1
        ELSE c.field1
    END as field1,
    CASE a.TType 
        WHEN 'E' THEN b.field2
        ELSE c.field2
    END as field2,
    CASE a.TType
        WHEN 'E' THEN b.field3
        ELSE c.field3
    END as field3 -- etc. etc.
FROM table1 a
LEFT JOIN table2 b ON a.SID=b.SID AND a.TranID=b.TranID
LEFT JOIN table3 c ON a.SID=c.SID AND a.TranID=c.TranID
WHERE
    a.DateEntered = (
        SELECT MAX(a1.DateEntered) FROM table1 a1 WHERE a.sid=a1.sid
    )

SELECT * FROM (
    SELECT b.*
    FROM table1 a
    LEFT JOIN table2 b ON a.SID=b.SID AND a.TranID=b.TranID
    WHERE
        a.TType='E'
        AND
        a.DateEntered = (
            SELECT MAX(a1.DateEntered) FROM table1 a1 WHERE a.sid=a1.sid
        )

    UNION

    SELECT b.*
    FROM table1 a
    LEFT JOIN table3 b ON a.SID=b.SID AND a.TranID=b.TranID
    WHERE
        a.TType <> 'E'
        AND
        a.DateEntered = (
            SELECT MAX(a1.DateEntered) FROM table1 a1 WHERE a.sid=a1.sid
        )
) targetTable
ORDER BY 
    targetTable.field1 ASC -- or whatever

SELECT Id,Name, Age,City, AdmDate 
FROM IP LEFT JOIN MDoc
ON IP.DoId=MDoc.DoId 
WHERE AdmDate >= '2003-11-15' AND
AdmDate < DATEADD( Day, 1, '2003-11-15' )
ORDER BY IP_Id