How to build a query to join tables?

Question

Android

Help build a query that will join two tables on a common field.
There is a table of products and there is a table of categories. Both tables have a common field - id_cat.
It is necessary to build a query so that, say, in the products table, opposite each product name, a category column is added so that the id_cat indexes of one table are equal to the id_cat indexes of another table.

Answer 1

With such accuracy - only industrial meters. Household such will not provide most likely.

Answer 2

Exists, only inaccessible to mere mortals.
You can allow a maximum accuracy of 1-3 cm. And then by combining autonomous positioning and corrections from the base station

Answer 3

Start from here

Answer 4

You need several sensors to get real-time data, read here:
https://docs.microsoft.com/ru-ru/windows/uwp/devic...
Sufficiently accurate sensors are used when creating movies and games, here is an article with types such (mechanical, gyroscopic, magnetic, etc.):
https://masterok.livejournal.com/1614463.html
These cost 5k raccoons. But there are homemade ones in our country, which are assembled on the knee for $ 150 and 8 months:
https://habr.com/post/392353/

Answer 5

SELECT goods.goods_name, goods.price, categories.cat_name 
FROM goods
LEFT JOIN categories ON goods.cat_id = categories.cat_id