0

Hi guyz,,
I have 2 table like,
table1

Name, Number
Gates 123456789
Bill 987456321
John 874123658
Peter 562314752

table2

Number, Message
123456789 Hai hello
874123658 Gudmorning
123456789 Something Went
123456789 verY Nice morning
562314752 Hai spidy..

My Question is how to select all records from table 2 and also i want to display the correspondence name to each numbers ,
I WANT RESULT LIKE THIS

Name Number, Message
Gates 123456789 Hai hello
John 874123658 Gudmorning
Gates 123456789 Something Went
Gates 123456789 verY Nice morning
Peter 562314752 Hai spidy..

3
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by mohamedasif18
0
SELECT t1.name, t1.number, t2.message from table1 t1 inner join table2 t2 ON t1.number=t2.number

Edited by simplypixie: n/a

0

Hi simplypixie, Thank you very much for your reply.. Your code worked me fine.. Thanks a lot..

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.