MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Bruce Feist Date:March 19 2003 5:49pm
Subject:Re: Re: another table to query!
View as plain text  
Andrew wrote:

>I have just discovered through luck that I need to have the same record in
>(table items) accessable if it is listed as being in more than one city (table
>city).  Obviously I don't want to create new records for the same item so it can
>be displayed if it's in different cities.  Is the best way to do this to create
>a new table and call it reference_city with items.ItemID and city.CityID as the

Yes, although I'd probably call it item_city to make it more obvious
what it is.

Bruce Feist

PS If you specify sql,query,queries, or smallint in a message to this 
mailing list, it doesn't get nuked as spam!

Re: Re: another table to query!Bruce Feist19 Mar