CodeIgniter Forums
Database relationships - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Database relationships (/showthread.php?tid=68596)



Database relationships - Martin7483 - 08-02-2017

Hi,

When using one of the following relationships between models ;
  • one to one
  • many to one
  • one to many

If I would like my query to return all records including the relations is this statement true or false?

Statement:
All three types use a single JOIN clause to return all records including the relations


RE: Database relationships - PaulD - 08-02-2017

True (IMHO)