Table Join Problem Again

2008-10-20 Thread MDB
Hello all, I am having a heck of a time trying to understand how to setup table joins. First I have the following 3 tables: scheduler_customers Primary Key = id tenant_service_approved Primary Key = tenant_service_approved_id scheduler_customers_tenant_service_approved Columns:

Re: Table Join Problem Again

2008-10-20 Thread soldier.coder
Short answer is no, you do not. EVERY table in cake must have primary key id which is autonumber int. When you refer to the primary key of another table, it is that tablename + _id. On Oct 20, 11:31 am, MDB [EMAIL PROTECTED] wrote: Hello all, I am having a heck of a time trying to

Re: Table Join Problem Again

2008-10-20 Thread MDB
Thanks, I will try that out. On Oct 20, 2:03 pm, soldier.coder [EMAIL PROTECTED] wrote: Short answer is no, you do not. EVERY table in cake must have primary key id which is autonumber int. When you refer to the primary key of another table, it is that tablename + _id. On Oct 20, 11:31