MySQL how to do sampling with replacement id at the names from another table?
There are 2 tables. In the first 2 fields: ID and title, the second data, and substitutes the person ID from the first table. (relationship 1 to many). How to write a query to get out all the data from table 2 and instead of ID -shnik of table 1 was the name of it? (ID to replace the name).
ID Mileage Type of vehicle
1 22000 1
2 23000 2
3 32000 1