I have a problem that I know can be solved if I can only explain it properly.
I have 3 tables, clients, projects and list_of_lists. Each has an Id field
select
c.id as client_id, p.id as project_id, l.id as list_of_lists_idfrom
clients c inner join list_of_lists l on c.id = l.client_idinner join projects p on c.id = p.client_id
This gives me every client, their projects and every list. I want most of this but not all.
select
c.id as client_id, p.id as project_id, l.id as list_of_lists_idfrom
clients c inner join projects p on c.id = p.client_idinner join list_of_lists l on p.id = l.project_id
This gives me only those lists that are associated with specific projects.
If you havent guessed already Im trying to recover from bad database design.
So what Im looking for is a list, like that of the first query, but if a project only has specific lists associated with it, I want only those from the second query.
Does that make any sense?
Any help is appreciated
Chad