I'm working on a small project but i have problems querying multiple tables.
Here are my tables:
Now i want to get the whole table content:
I want to return those fields in one row of the grid, but unfortunately with no luck the return is in 2 rows.
Code: Select all
select * from (tb_client join tb_city on tb_client.id_city_born=tb_city.city_id or tb_client.id_city_died=tb_city.city_id) join tb_country on tb_country.country_id=tb_city.country_id