I have an SQL querry that creates a comparison table based on taxonomy and am wondering if it is possible to recreate using Views??
If a node has a taxonomy it selects the node tile and 'Y' else 'N' A sample of the SQL code is:
enter code here
select a.title AS SOFTWARE,
COALESCE((select 'Y'
from taxonomy_index b, taxonomy_term_data c
where c.tid = b.tid
and c.vid = 3
and b.tid = 17
and a.nid = b.nid), 'N') AS 'Results Recorded',
COALESCE((select 'Y'
from taxonomy_index b, taxonomy_term_data c
where c.tid = b.tid
and c.vid = 3
and b.tid = 13
and a.nid = b.nid), 'N') AS 'Free Trial'
from node a
where a.type = 'Software'
Many Thanks Julie