Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Active Record + Join SQL Problem
Active Record + Join SQL Problem
  • El Forum
    Unregistered
  •  
#5
02-19-2009, 07:13 AM

[eluser]meigwilym[/eluser]
You need a Foreign Key for each table to another, then it's simply a matter on SELECT FROM table1 INNER JOIN table2 ON table1.fk = table2.id with a ORDER BY thrown in at the end.

If your db design was good it should be no problem.

Mei


Messages In This Thread
Active Record + Join SQL Problem - by El Forum - 02-18-2009, 06:26 PM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 02:19 AM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 03:49 AM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 06:03 AM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 07:13 AM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 01:49 PM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 02:21 PM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 02:26 PM
Active Record + Join SQL Problem - by El Forum - 02-19-2009, 02:52 PM
Active Record + Join SQL Problem - by El Forum - 02-20-2009, 08:51 AM
Active Record + Join SQL Problem - by El Forum - 02-28-2009, 03:50 PM
Active Record + Join SQL Problem - by El Forum - 02-28-2009, 05:01 PM
Active Record + Join SQL Problem - by El Forum - 02-28-2009, 05:04 PM



Theme © iAndrew 2016 - Forum software by © MyBB