Adding a the rows field from one table to the other

[theknight]

This may be a join question but I am unsure:

Table location
- ID
- locations

Tabel notices
- ID
- noticeTypes
- default

What I want to do, is to get all the rows in "locations" and insert them into "noticesTypes" field in table notices. Is this possible?

I think with "Join", you just join both tables together?

[dagon]

guessing you talking about mysql

12.2.5.1. INSERT ... SELECT Syntax