Rob Desbois schrieb:
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 learn
Rob Desbois schrieb:
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,
Rob Desbois schrieb:
To those who responded - read the question.
He wants to combine the values from the data column of *2* rows into one, not
just a straightforward string concatenation.
Sorry but you want me to write the whole SQL query?
He has to use his brain.
Grouping and joining the
Hi, the GROUP_CONCAT worked. Thank you. However, I'm getting duplicates in
the "all_data" column. Is there a function like array_unique in PHP to
remove these duplicates?
I tried DISTINCT but that did not work.
Thank you.
--
View this message in context:
http://www.nabble.com/NewbieCREATE
Thank you!
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171108
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi,
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
--
site
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
--
Search the Manual for CONCAT.
SELECT
/Peter
-Original Message-
From: z247 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 04, 2006 10:02 PM
To: mysql@lists.mysql.com
Subject: Newbie - CREATE VIEW Question
Say I have the following tables;
siteID,name
--
site
