Help with a mapping query

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Andrew Stanton Ten Centuries Points: 1115 More actions · Answer 1

Can you give us more details? I'm not 100% on what you are looking to accomplish.

DavidP-340734 Right there with Babe Points: 737 More actions · Answer 2

Are you looking for something like this?

CREATE TABLE Files (id INT, filename VARCHAR(255))

CREATE TABLE Email_Lookup (id INT, emailaddress VARCHAR(255))

CREATE TABLE Mapping (Files_id INT, Email_Lookup_id INT)

INSERT INTO Files VALUES(1, 'test 1')

INSERT INTO Files VALUES(2, 'test 2')

INSERT INTO Files VALUES(3, 'test 3')

INSERT INTO Files VALUES(4, 'test 4')

INSERT INTO Email_Lookup VALUES(1, 'me@aol.com')

INSERT INTO Email_Lookup VALUES(2, 'you@aol.com')

INSERT INTO Email_Lookup VALUES(3, 'everyone@aol.com')

INSERT INTO Mapping VALUES (1, 1)

INSERT INTO Mapping VALUES (1, 2)

INSERT INTO Mapping VALUES (3, 2)

INSERT INTO Mapping VALUES (2, 3)

SELECT f.filename,

e.emailaddress

FROM Files f,

Email_Lookup e,

Mapping m

WHERE m.Files_id = f.id

AND m.Email_Lookup_id = e.id

ORDER BY emailaddress

/* Results

*/