On Jul 12, 8:43 am, Patrick <g...@geen.nlwrote:
Quote:
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.
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
