Page 1 of 1

how to control the line displayed when using group

Posted: Thu Jun 08, 2006 5:21 am
by x
ill make a basic form of the query im doing to make it easier for readers

query

select * from job group by company order by RAND() limit 10

the problem is the query shows only one entry under each company,
for example company ABC have two job record only one of those job are always showing.

is there a way i can control this so that the other jobs from the same company can be displayed at random?

Posted: Thu Jun 08, 2006 9:44 am
by feyd
lose the group by.