Hi,
I'm pretty new to SQLite, and am just looking for a few pointers on SQL
queries, this is an example of a query from a crapy MS Access database that
I want to convert to SQLite, but it fails. it says c.group_id does not
exist.
I'm wondering if anyone has got some tips on multiple joins, I suspect
SQLite doesn't like these joins very much and I will need to rewrite some of
the queries.
Regards,
Chris.
Query is :-
Select *
from
(
select b.group_id from users a INNER JOIN
(
select group_id from group_users
Where user_id = 'pass'
) as b
on (a.user_id = b.user_id)
Where a.password = 'pass'
) c
inner join groups as d on
(c.group_id = d.group_id)
