Select query help

Hi All,

I am trying to whip up a quick query to pull all ticketing links for a specific production season.  It should display 1 row for each date (if there is not a keyword associated with that specific perf, then I would like a null field).  For some reason, I'm getting 2 rows for each date with a ticket link.  Any ideas?  Thanks!

SELECT p.perf_dt,p.perf_no,
CASE
WHEN tkw.tkw =8 THEN 'cart.mnhs.org/.../SelectSeating.aspx as varchar(10))

END

FROM t_perf p
LEFT JOIN t_inventory i on p.perf_no = i.inv_no
LEFT JOIN tx_inv_tkw tkw on i.inv_no = tkw.inv_no

WHERE p.prod_season_no=7246

ORDER BY p.perf_dt

Results look like this