-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 |
]
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 VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT=Types
= 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]
Gesendet: Freitag, 25. Juli 2003 23:08
Betreff: Selecting unique values
I have two tables
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
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