I wonder if it is possible for MySQL to create a virtual table upon
every SQL selection by grabbing emails from two columns into an
imaginationary table in the server's memory. So, what is the SQL term
for that? That way, I can match it against it to see if it is a match
or not. I can do that with with DB2 but MySQL is different.
Thanks,
Scott
----- Original Message -----
From: "Scott Fletcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 20, 2004 3:54 PM
Subject: How to make 1 primary key work for 2 columns????
Hi! I'm trying to figure out how to make this possible... What I have
here is a company address, along with both the primary contact and
secondary contact. In them is one email address from the primary
contact and one other email address from the secondary contact. Problem
is setting an unique primary key that treated the 2 columns as one
column with unique email address.
Let's this example below
--snip-
| First_Email | Second_Email |
------------------------------------------------
| [EMAIL PROTECTED] | [EMAIL PROTECTED] |
-----------------------------------------------
| [EMAIL PROTECTED] | [EMAIL PROTECTED] |
-----------------------------------------------
--snip-
be like this below where there is no two same email address....
--snip-
---------------------------------------
| [EMAIL PROTECTED] |
---------------------------------------
| [EMAIL PROTECTED] |
---------------------------------------
| [EMAIL PROTECTED] |
---------------------------------------
| [EMAIL PROTECTED] |
---------------------------------------
--snip-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
