2 Tables

["Denis Mettler" <taipan@xxxxxxxxxxxxx>]

Hi there,

Another problem.
i have the following tables:

table 1:
id, primary key, auto increment
name varchar(50)
city varchar(50)
phone varchar(25)


table 2:
categorie_id, primary key, auto_increment
kategorie varchar(50)


in table one i have the contacts
and in table two the categories (Business, privat...)

but how can i link these tables for a query.
i ask because i know that mysql doesn't support foreign keys.

thanks in advance
denis

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread68552@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php