Member Avatar for lloydsbackyard

how do i join fields from 3 or more tables....please give me a sample code...thanks

  • 2 Contributors
  • 1 Reply
  • 44 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff 
select a.*,b.*,c.* from a join b on a.x=b.x join c on b.x=c.x

or

select a.*,b.*,c.* from a join b on a.x=b.x join c on a.x=c.x
Edited by smantscheff because: n/a
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.