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
>> 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
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,
> 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
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
bble.com/Newbie----CREATE-VIEW-Question-tf1890326.html#a5171910
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/[EMAIL PROTECTED]
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
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
, (M,P)
site2, RSQ, (Q,Y)
where all the related column data in the second table is placed in another
column. How can I do this? Is there a function that can group these values
into one variable or array?
Thank you
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW
12 matches
Mail list logo
