mysql - Query a duplicate data from two different tables -


i have 2 tables on dba.

table1: name_id | id | lastupdated | name  table2: user_id | action_view | mob_no | process | result 

these 2 tables related name_id=user_id.

i want query users, have same mobile number whom column result 1 (meaning successful).

lets name(john in table1) have 3 different mobile numbers in table 2 , each result 1.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -