Member Avatar for youvi

Hello,

Please provide me the query to join 3 tables using INNER JOIN...

Thanks

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol 
SELECT * FROM t1, t2, t3 WHERE t1.id = t2.id AND t2.id = t3.id;

That's for inner join. Left joins more difficult. However, I do reckon your Google skills are as good as anybody here - I'm sure you could find this info if you tried.

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.