l Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: Wednesday, August 25, 2010 1:23 PM
> To: [MySQL]
> Subject: Retrieve three columns in sub query
>
> Hi
>
> Is it possible in MySQL 5.1 to retrieve three columns in a select sub-query
Not tested, but i think it could work for you:
SELECT
student_age,
(SELECT
student_subjects_id
FROM
student_subjects
ORDER BY
RAND()
LIMIT 1) as subject_id,
(SELECT
random_mark
FROM
student_subjects
having
student_subj
select ci.*, ct.* from (select name, countrycode from city) ci, country ct
where ci.countrycode = ct.code
Regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 1:23 PM
To: [MySQL]
Subject: Retrieve three columns in sub
I thought as much, if anyone else can shed some light that would be great.
If not, I'm going to have to write an additional query.
2010/8/25 João Cândido de Souza Neto
> As far as I know sub-queries intends to be an only one column and row
> result.
>
> --
> João Cândido de Souza Neto
>
> "
As far as I know sub-queries intends to be an only one column and row
result.
--
João Cândido de Souza Neto
"Tompkins Neil" escreveu na mensagem
news:aanlkti=djkujcsg=kf29sjsp0yllhmhb02mqzdvzd...@mail.gmail.com...
> Hi
>
> Is it possible in MySQL 5.1 to retrieve three columns in a select
>
Hi
Is it possible in MySQL 5.1 to retrieve three columns in a select sub-query
like below :
SELECT student_age, SELECT (student_subjects_id, random_mark, subject FROM
student_subjects ORDER BY RAND(), LIMIT 1)
FROM students
WHERE student_age > 10
ORDER BY RAND()
LIMIT 1
I've looked and tried eve
