Gerald,
God, it getting scary now, I'm actually starting to grasp all this stuff now.
this is exactly what I came with last nite, but just didn't understand what your
idea was when I first read it. :) This appears to be the best solution.
Thanks for your help,
Cheers,
>>On Wed, 11 Jul 2001 12:43:40 -0500, Gerald Clark <[EMAIL PROTECTED]>
> wrote:
>>t2 has a line for each of the multiple IDs
>>
>>MYKEY ID
>>---- -------
>>key1 IM34456
>>key1 IM34457
>>key1 IM34458
>>key2 IM34457
>>key2 IM34567
>>
>>...
>>
>>t1 would have lines like ( using your fields instead of name,addr,city )
>>
>>MYKEY NAME ADDR CITY
>>----- ----- ----- -----
>>key1 name1 addr1 city1
>>key2 name2 addr2 city2
>>
>>
>>select t1.MYKEY, ID, NAME, ADDR, CITY
>>from t1,t2 where t1.mykey=t2.mykey and ID='IM34457'
>>
>>returns
>>
>>key1 IM34457 name1 addr1 city1
>>key2 IM34457 name2 addr2 city2
>>...
>>
>>
>>MikeBlezien wrote:
>>
>>> Gerald,
>>>
>>> You lost me on the second table, t2?? The t1 table would store a 'mykey' and the
>>> multiple values(ID's) and table t2 would have the reference 'mykey' to table t1
>>> and the ID column,... this is where you loose me??
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
