> Hello,
>
> I would like to do this witihn mysql:
>
> SELECT con.id,con.name FROM contacts con, registrar_contact reg
> WHERE NOT con.id IN
> (SELECT contactid FROM registrar_contact WHERE registrarid=1)
>
> can someone tell me how to do this ?
>
> contacts table consists of:
> id(primary key
Hello,
I would like to do this witihn mysql:
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
can someone tell me how to do this ?
contacts table consists of:
id(primary key)
name
registrar_contac
Hello,
I am creating tables within MySql 3.23.49. I want to add relation ships
between different tables. I tried to do this with foreign key statements.
For example:
CREATE TABLE domains (
domain varchar(100) NOT NULL,
registrarid int(10) NOT NULL,
foreign key (registrarid) REFERENCES reg
