Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=5 and ((Tcdal<='2020-03-08' and Tcall>='2020-03-08') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=33 and ((Tcdal<='2020-03-08' and Tcall>='2020-03-08') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=31 and ((Tcdal<='2020-03-08' and Tcall>='2020-03-08') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
