Re: Help with joins...

Mickael Pervinski wrote: I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects - ProjectID MaleID FemaleID SELECT M.AnimalNAME AS male, F.AnimalNAME AS female FROM Projects P INNER JOIN Animals M ON P.MaleID = M.animalID INNER JOIN

Help with joins...

I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects - ProjectID MaleID FemaleID Let's say Projects holds MaleID:1 and FemaleID:2 I need to write a query that joins these tables, and basically pulls back two sets of animal information per one record in the

Re: Help with joins...

On 7/21/07, Crit wrote: Any suggestions? I am not even sure if this is the best way to setup the projects table.. so if it's not... let me know... I'd restructure your DB. Maybe use a join table instead? projectAnimals projectAnimalID projectID animalID Knowing nothing about what your

Re: Help with joins...

I'm confused to your question. Based on the 2 tables you have listed, can you say what fields you want in the new table after the join? On 7/21/07, Mickael Pervinski [EMAIL PROTECTED] wrote: I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects -