Member Avatar for mohamedasif18

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
  • 166 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by mohamedasif18

Recommended Answers

All 3 Replies

Member Avatar for simplypixie 
SELECT t1.name, t1.number, t2.message from table1 t1 inner join table2 t2 ON t1.number=t2.number
Edited by simplypixie because: n/a
Member Avatar for appugharindia

Thank you, very good info.

Member Avatar for mohamedasif18

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.