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 case
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, it can
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 this;
siteID,name,data