Cacher is the code snippet organizer for pro developers

-- adicionar query GetDataByPartida(@status, @idpartida);
select * from bilhete where 
  idbilhete in ( select bilhete_idbilhete from aposta where apostasjogos_idapostasjogos = @idpartida ) and
  statusBilhete = @status