-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 25 July 2003 17:38, Alec Smith wrote:
>
> But what I really need is a result like
>
> +--++
>
> | name | domain |
>
> +--++
>
> | hostdom1 | abc123.com |
> | hostdom2 | abc127.com |
> | hostdom3
That does exactly what I needed. Thanks much for the tip, it'll save me a
weekend digging through the web trying to finish a project for work.
Alec
On Sat, 26 Jul 2003, Yves Goergen wrote:
> i'd try something like
>
> select t.name, d.domain
> from domain_types t, domains d
> where t.type_id =
i'd try something like
select t.name, d.domain
from domain_types t, domains d
where t.type_id = d.type_id
group by t.name
order by t.type_id
or something with a 'join on t.type_id = d.type_id'
-yves
-Ursprüngliche Nachricht-
Von: "Alec Smith" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED
