Laravel mysql join issue

Question

I have 2 tables both the table have exact same field names and datatype.

ISSUES: 1) I'm unable to receive data from both columns 2) I also need to count phone no in both table

The field names are member_id, name , phone

`SAMPLE DATA IN MEMBER TABLE`
------------------------------
member_id | name | phone     |
------------------------------
100000    | ABC | 9876543210 |
-----------------------------*

`NOW SAMPLE DATA IN MEMBER_TEMP TABLE`
------------------------------
member_id | name | phone     |
------------------------------
100001    | DEF | 9876543210 |
-----------------------------*

`NOW EXPECTED RESULTS/ OUTPUT EXPECTED`
------------------------------
member_id | name | phone     |
------------------------------
100000    | ABC | 9876543210 |
------------------------------
100001    | DEF | 9876543210 |
-----------------------------*

BELOW IS LARAVEL QUERY BUILDER

$member_info = DB::table('member')->select('member_temp.*','member.*')->where(
            array(
            )
    );

    $member_info = $member_info->join('member_temp','member_temp.phone', '=', 'member.phone')
            ->get()->toArray();

//RAW MYSQL QUERY

select *
from `member`
inner join `member_temp`
    on `member_temp`.`phone` = `member`.`phone`

THANKS IN ADVANCE

Is that the actual MySQL query you want to run? What about the counts? — Tim Biegeleisen
– Tim Biegeleisen, Commented Aug 18, 2018 at 10:45
@Tim Biegeleisen as mentioned i need to take result OR Count of matching phone number from both table. When i run the query i get only one result from a particular table — Pavan Baddi
– Pavan Baddi, Commented Aug 18, 2018 at 10:47
Please include sample data for both tables, along with the expected output. — Tim Biegeleisen
– Tim Biegeleisen, Commented Aug 18, 2018 at 10:48

Usman Jdn · Accepted Answer · 2018-08-18 11:17:17Z

1

I suggest you should use eloquent model to get phone column from both tables. it will always conflict in fluent query(join) because of same column name

answered Aug 18, 2018 at 11:17

Usman Jdn

8279 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark C. · Accepted Answer · 2018-08-18 18:04:16Z

1

I think you have started out with the wrong raw sql query.

It seems like you are looking for something more like this to get all the data you want out of the database:

select a.memberid as MemberId, b.memberid as MemberTempId, a.name as MemberName, 
b.name as MemberTempName, a.phone from member as a join member_temp as b on 
member.phone = member_temp.phone;

answered Aug 18, 2018 at 18:04

Mark C.

4084 silver badges14 bronze badges

Collectives™ on Stack Overflow

Laravel mysql join issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related