First of all, excuse me if I use non standard terms, since I'm new to MySql and Sql.

I have table I as follow

Id (the primary key)
Name

I need to add a new table II as follows:

URL (the primary key)
Id (I.e. belongs to this Id. Value can only be taken from Table I, if not there, then rejected. Values can be repeated accross records)

I use Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32) on windows xp.

Thanks!

That doesn't sound like a MySQL version number to me. Could you mean PostgreSQL by any chance?

-PatP