>Hi All MySQL ers > >I am now starting to confuse myself so everyone else should be just >fine with this query problem / clarification! > >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 columns? > >Basically the items are being called when an item is in a city and the >same item will more than likely be in more than one city. > >Thanks >Andrew > > > > >********************************************************************** >Information in this email is confidential and may be privileged. >It is intended for the addressee only. If you have received it in error, >please notify the sender immediately and delete it from your system. >You should not otherwise copy it, retransmit it or use or disclose its >contents to anyone. >Thank you for your co-operation. >**********************************************************************
--------------------------------------------------------------------- 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
