如何在已有的SQL查询的语句中,再添加一个查询条件?

日期:2018-03-22 14:35:32 人气:1

如何在已有的SQL查询的语句中,再添加一个查询条件?

select * from ( select a.*, b.TicketTypeKind from TBL_TicketBasic as a left join TBL_TicketType as b on a.TicketType = b.TicketTypeNo )as c where ( (c.TicketTypeKind = '2' and c.InDatetime<dateadd(month,-3,getdate())) or (c.TicketType
    A+
热门评论