thecrew: data entry wonders whether this is an easy way to create an associative entity table with a query.
I was thinking about using a "select" statement, i.e.
insert into orders
values
(select ...);
But i am not so sure how to implement this? I wasn't able to get it to work.
Any suggestions would be welcomed.
This would be nice, but it just will not work. How will you join the tables if there is no associative entity table to link them?