Add more data into existing rows and column at SQL

[Pisca]

Hi Guys !

I have a table with existing data in column ( let's say Notify column which contains email addresses) and I need to add in more email address ..
I knew i might able to use CONCAT but I have like 2000 rows and need to add different email address per row .

Good thing is those email address are store in table of same DB and might able to call with let's say ' select email from mail where name='Test'

Any idea how can I do this ? Do i need like inner join or something ?

[Exequiel]

are you referring for inserting or update? I really don't get your point, but if you want to add another data on the row who have already a data you must determine the id of that row, example, UPDATE TABLE_NAME SET email='zick@yah oo.com',new_dat a='new_data' WHERE id='200'

[Rabbit]

You really shouldn't store more that one piece of data per cell in a table. It breaks the rules of normalization and will make querying it later a nightmare. You can learn more about normalization from our tutorial here: http://bytes.com/topic/access/insigh...ble-structures