Welcome Guest, Not a member yet? Register   Sign In
Trying to join two different IDs with AR
#1

[eluser]spmckee[/eluser]
So I have a table called "projects"

Projects
--------------------------------------
| project_id | group_id | company_id |
--------------------------------------
| 1 | 4 | 2 |
--------------------------------------
| 2 | 1 | 2 |
--------------------------------------
| 3 | 0 | 1 |
--------------------------------------

I then have two other tables "groups" and "companies" that I am wanting to grab info from and include in my result. I can grab the info from one table or the other with join but I can't get the info from both tables at then same time.

Any ideas? Thanks.


Messages In This Thread
Trying to join two different IDs with AR - by El Forum - 09-17-2009, 11:29 AM
Trying to join two different IDs with AR - by El Forum - 09-17-2009, 01:40 PM
Trying to join two different IDs with AR - by El Forum - 09-17-2009, 01:43 PM
Trying to join two different IDs with AR - by El Forum - 09-17-2009, 02:08 PM
Trying to join two different IDs with AR - by El Forum - 09-17-2009, 02:18 PM



Theme © iAndrew 2016 - Forum software by © MyBB