Programming style?

2001-09-18 Thread Marcus Young
Hi, just after a bit of advice on programming style I have one main table which holds keys to records in other tables. There is also an additional table that uses the main tables ID field as a key. I need to generate a view that joins data from each of these tables. Should this be achie

INSERT SELECT QUESTION

2001-09-09 Thread Marcus Young
Hi, I'm fairly new to MySQL. I'm trying to insert data into a table where one field is derived from a SELECT on another table (a key) and the other fields are defined directly (eg field_01="abcd") . The formats I have been trying don't appear to be correct. Is the commbined insert possible