sql - 仅从类型中获取一行

Question

我有一张 table 票等表日志 . 中的每一行都有很多日志票 .我想知道某个字符串是否在某个日志中，然后从 中获取一个寄存器票哪一个都没有关系，因为我只想每个 得到一行票 .这是我目前所拥有的:

SELECT ticket.id,ticket.description,ticket.owner 
FROM ticket
JOIN log
ON (log.ticketid=ticket.id)
where log.description LIKE '%someparameter%'

在这种情况下我该怎么办？

Answer 1

SELECT
  *
FROM
  ticket
WHERE
  EXISTS (SELECT *
            FROM log
           WHERE log.ticketid = ticket.id
             AND log.description LIKE '%someparameter%'

或者...

SELECT
  ticket.id, ticket.description, ticket.owner 
FROM
  ticket
INNER JOIN
  log
    ON (log.ticketid=ticket.id)
WHERE
  log.description LIKE '%someparameter%'
GROUP BY
  ticket.id, ticket.description, ticket.owner