-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
ns 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
MAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Freitag, 25. Juli 2003 23:08
Betreff: Selecting unique values
> I have two tables as below:
>
> CREATE TABLE domain_types (
> type_id INT(4) NOT NULL AUTO_INCREMENT,
> name VARCHAR(10) UNIQUE NOT NULL,
> description VARCHA
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT="Types of domains we store";
CREATE TABLE domains (
domain_id INT(6) NOT NULL AUTO_INCREM
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT="Types of domains we store";
CREATE TABLE domains (
domain_id INT(6) NOT NULL AUTO_INCREM
