Does MS-Access allow usage of pipes in sql query? eg. ¦¦
I have a query below suggested for sqlite using pipes.
When I try to use it in MS-Access, I get an error because of the pipes.
What should I replace that with to make this query work?
I have a query below suggested for sqlite using pipes.
When I try to use it in MS-Access, I get an error because of the pipes.
What should I replace that with to make this query work?
Code:
select t.students, c.name class, t.students_count
from (select sc.idc, min(s.name) || case when count(*)>1 then ' +' else '' end students, count(*) students_count from student s inner join studentclassjoin sc on (s.id=sc.ids) group by sc.idc) t
inner join class c on (t.idc=c.id)