如何在已有的SQL查询的语句中,再添加一个查询条件?
如何在已有的SQL查询的语句中,再添加一个查询条件?
日期:2018-03-22 14:35:32 人气:1
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