Good afternoon, i haven't done much with php and Mysql the past 2 years so my knowledge is not really up-to-date.
i'm not a hero when it comes to math. actually, it's a weakness but trying to fix that. i made a query where i compare 2 tables against eachother and then i want to see a table that shows me results: the Relation + Surname should match. i have chosen for those two because Surname was a required input and all contacts must have a relation. also, in those tables there are fields that have completely messed up information that shouldn't be there in the first place, phone numbers as names f.e.. that aside i made this query: $sql = 'SELECT table_a1.Surname, table_a2.Relation, table_a1.City FROM table_a1 INNER JOIN table_a2 ON table_a1.Relation=table_a2.Relation';w I get a row back. my question: is this an appropiate and common way to get this job done? im NOT used to dig deep in this kind of stuff but i can see in the future i will need a few handy scripts. tips and advice are very welcome.