|
|
Posted by J.O. Aho on 07/19/06 14:28
Frankly wrote:
> honestly i am afraid of losing
> your respect and your help. look around there is a reason you are the only
> one helping me or even talking to me.
Think this thread got so long that people don't want to start from the top and
read and see what happens and this time of year people ten to leave town and
spend time on a hot beach and get BBQ:ed.
> i thought left joins were used for many to many and inner joins were for 1
> to many and it seems even that was wrong.
Using the different types of joins are there so you can get the result you
want, as you may noticed from my reply, depending on how to join the results
was different.
It can be good to decide what kind of output you want and then test the
different joins and see which one delivers what you want, I think this will
give you a good lesson how to use joins.
I'm not sayin you shouldn't use phpmyadmin, but you will need to know how to
do things in pure SQL when you are starting with your php code.
//Aho
Navigation:
[Reply to this message]
|