>> I agree that it's often better to point someone in the right direction
>> rather than just writing the query for them, but in this case it was a
>> newbie question.
>And therefore it's most important that he tries to learn how to look at
>the doc.
Remembering my own troubles learning MySQL, i
> Sorry but you want me to write the whole SQL query?
> He has to use his brain.
> Grouping and joining the tables.
> I'm not here for doing your or his work!
Barry,
I agree that it's often better to point someone in the right direction rather
than just writing the query for them, but in this cas
>> z247 schrieb:
>> Say I have the following tables;
>>
>> siteID,name
>> --
>> site1, XYZ
>> site2, RSQ
>>
>> ID,site,data
>>
>> 1, site1, M
>> 2, site2, Q
>> 3, site2, Y
>> 4, site1, P
>>
>> ... etc.
>>
>> And I want to create a view like
