select from table

Discussion:

select from table

(too old to reply)

Patrick

2007-07-12 12:43:19 UTC

Hi,

Can anyone show me how to do the following:

From a table I would like to retrieve the following:

company and websites.

When I do a select on on this table i'll get

company 1 - website 1
company 1 - website 2
company 1 - webiste 3

company 2 - website 1
company 2 - website 2

etc.
But what I would like is:

company 1 website 1
website 2
website 3

company 2 website 1
website 2

etc.

Now I use the following select statement:
$query="select company, domainname from DOMAIN, CLIENT_PERSONAL_DATA,
USER where DOMAIN.idclient = CLIENT_PERSONAL_DATA.id";

Regards, Patrick.

David Ayres

2007-07-14 23:50:49 UTC

Permalink

Post by Patrick
Hi,
company and websites.
When I do a select on on this table i'll get
company 1 - website 1
company 1 - website 2
company 1 - webiste 3
company 2 - website 1
company 2 - website 2
etc.
company 1 website 1
website 2
website 3
company 2 website 1
website 2
etc.
$query="select company, domainname from DOMAIN, CLIENT_PERSONAL_DATA,
USER where DOMAIN.idclient = CLIENT_PERSONAL_DATA.id";
Regards, Patrick.

Patrick,

IMHO, that dataset wouldn't make much sense or be useful (even if it
were possible). What are you doing with this data?

Dave

Captain Paralytic

2007-07-23 12:48:40 UTC

Permalink

Try:
SET @head = '';
SELECT IF(@head=`company`,'',@head:=`company`) `company`,`website`
FROM `tab1`