Dear Sir,
You want something like:
select category_id, case when [login to view URL] like 'condition' then true else false end as flag from category_description a inner join sales_promotion b
on a.category_id=b.category_id
Wishing you the best,
Ionut Rosca