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
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