If you really don't know the structure, then you need to hope that all the tables have foreign keys. You can look at the dependencies of one of the tables, say Products, to see which tables are related to it. Then you can walk the chain to figure out how to connect the tables you want. Here's a great article from SQL Tip[/url]s that shows a ton of ways to get this done.