Shouldn't there be field MODE_ID in the Employee table? RBS
On Mon, Oct 21, 2019 at 3:44 PM Keith Medcalf <kmedc...@dessus.com> wrote: > > On Monday, 21 October, 2019 08:31, Winfried <codecompl...@free.fr> wrote: > > >Using the following tables, I need to find how employees from each city > >come to work. > > >====== Employees table: > >EMPLOYEE_ID | CITY_ID > >Cities table: > >CITY_ID | CITY_TXT > >Mode table: > >MODE_ID | MODE_TXT > > > >This is the type of output I need to get ultimately: > >CITY | WALKING | CYCLING | PUBLIC TRANSIT | CAR | OTHER > >City1 | 15% | 5% | 50% [ 25% | 5% > > No amount of queries or magical incantations will get you the results you > are asking for because there is no way to get from MODE_TXT to CITY_TXT. > That is, there is no way to compose the rest of the query as indicated by > the ... to obtain the data required to solve the problem: > > select EMPLOYEE_ID, CITY_TXT, MODE_TXT > from EMPLOYEES, CITIES, MODE > where .... > > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users