• Registered: 2006-04-30
  • Posts: 382

Topic: what's with the JOIN syntax

Whenver o perform junctions betwin to tables i use a

... where t1.a=t2.a AND t2.b=t3.b AND...

Everywhere i see these join things.

Are they prefered when it comes to performance?
What's the LEFT and RIGHT thing for?

  • Jansson
  • Former PunBB Developer
  • Offline
  • From: Sweden
  • Registered: 2003-01-06
  • Posts: 856

Re: what's with the JOIN syntax

http://www.w3schools.com/sql/sql_join.asp smile