Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-29 : 23:54:05
|
Fiachra writes "This is probably a simple one but here it goes.
I have a database which stores members with there own table. So far example I sign up and a table is assigned to me. I have another table that stores all the table names that are created dynamically.
If I am a member I can order things from this website. My own table stores a history of all my orders. Including information on which supplier I ordered my goods from.
As the website administrator I want to search through all the members tables and group all my results by the supplier.
So for instance lets say I am a member and I ordered a BMW from Eric's BMW's and a Merc from Tom's Mercedes.
When an order is placed an email is sent to the supplier with a url, wher they can confirm that they have received the order. When they confirm the order, the members table has a boleann field which is called confirmed and it is set to true.
I as the administrator want to be able to searech all members tables and find out who what suppliers are not confirming thier orders. I want just one big list. But I want all suppliers ordered.
I think that makes sense.
Thanks for your time." |
|
|
|
|
|
Joining Tables