>>
> There are obviously many possible variations of your query; I just
> stated one that was pretty close to your original query. It's really
> not clear to me yet what you were trying to do so I just wanted to show
> you typical syntax.
>>
>>
Ok sorry ppl I should have given a typical example in my script.
qsuedocode :
select * from shotlist
while row in result
select * from sources where sourceID IN (row[sourceID])
while row in result
append sources to string here
end while
output results to template row
end while
so it would be in a datagrid
Title Sources
my title here source1, source2 etc ...
If i were to do that in a normal join the rows would duplicate from a 1 to
many.
>>
> It really depends on what you already know. I think DB2 is pretty easy
> to use but 've been using DB2 for 20 years; I don't know what you will
> think, because I don't know anything about you.
>
woah 20 years ? you are an SQL veteran then :) I'm still a green
grasshopper of 5 years. Ok i'msure you dont know anything about me, and has made me
suggest to everyone
of a listee profilespage heheheh. Little bit about me, I am a PHP/Mysql/Java/Unix/Flash
Actionscript 2 developer fora Tv station in Sydney building business level web
applications.
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
