1 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Visual explanation of SQL joins

I thought this article describing SQL joins as Venn diagrams might be of interest to readers of this forum:

http://www.codinghorror.com/blog/archives/000976.html

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Visual explanation of SQL joins

Thanks Charles, that's a nice explanation. And before anyone asks, no, Recorder does not use any cross joins!

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Visual explanation of SQL joins

Thanks Charles - added to my favourites for reference!

Sarah Shaw
Biodiversity Information Assistant
JNCC