joints - extracting common results from comparing 2 tables
Taco Mathijs Hillenaar-Meerveld <[email protected]> Wed, 23 Oct 2013 14:15:33 +0200
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <CABW__QZp9d0O=MTp-BDEV7FQnbdUjN+mhx-sXfk_26+OgEnwhQ@mail.gmail.com> |
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.