Hello, I hope someone can help me out here,
I've inherited a database from long ago which has a lot of bills of materials as separate tables and the table name is the part number for that bill of material.
I need to join all of these tables so they can be exported to PSQL.
The tables all have the same fields within them (part no, qty, etc.)
I'd like to join them altogether with an additional field that shows the name of the table it came from.
is there an easy way to do this, nothing springs to mind right now, though its been a while!
Thanks for any help.
I've inherited a database from long ago which has a lot of bills of materials as separate tables and the table name is the part number for that bill of material.
I need to join all of these tables so they can be exported to PSQL.
The tables all have the same fields within them (part no, qty, etc.)
I'd like to join them altogether with an additional field that shows the name of the table it came from.
is there an easy way to do this, nothing springs to mind right now, though its been a while!
Thanks for any help.