storm warden wrote:
A relationship would work normally however witht the IMEI being 15
digits
and the prefix only being 6 (or the 1st 6 digits of the IMEI).
You can create a JOIN using these criteria e.g.
SELECT * FROM Requests INNER JOIN Handsets
ON LEFT(Requests.REQIMEI,6) = Handsets.Prefix;
but not a FOREIGN KEY.
Jamie.
--
|