Please bear with me if this question sounds simple as SQL is definately not my forte.
I want to insert a new record into a table. The table has relationships with other secondary tables, For example:
Table StoreCategories (a store can have many of these)
I want to insert a new store, get its ID and insert some categories in one go.
How do I go about this?
View Complete Post