Ambiguous column name 'AssetID'

[Casey Westover]

I'm getting a Ambiguous column name 'AssetID' error when i execute this stored procedure. Can someone help?

SELECT  @SqlSelect = "SELECT  h.Location " 
                + "       ,h.LocNo "
                + "       ,h.AssetID " 
                + "       ,h.AssetNo "
                + "       ,h.Description " 
                + "       ,h.AFENo "
                + "       ,h.Dept " 
                + "       ,h.SerialNo " 
                + "       ,h.Op "
                + "       ,h.NonOp " 
                + "       ,h.Disp "
                + "       ,h.DispDate "
                + "       ,h.UsefulLife " 
                + "       ,h.AcqDate "
                + "       ,h.AcqValue " 
                + "	      ,h.Depr "
                + "       ,h.NetBook " 
                + "       ,h.SalvValue "
                + "	      ,h.Active " 
                + "       ,h.PlaceServ "
                + "       ,d.DetailIndex " 
                + "       ,d.AuditDate " 
                + "       ,d.QuarterAudited "
                + "       ,d.Auditor " 
                + "       ,d.Labeled "
                + "       ,d.MaintNo "
                + "       ,d.TagLoc " 
                + "       ,d.AreaDesc "
                + "       ,d.Notes " 
                + "FROM FASTrackingHeader h "
                + "JOIN FASTrackingDetail d " 
                + "ON h.AssetID = d.AssetID " 
					 
        EXEC (@SqlSelect + @SqlWhere + @SqlOrderBy)