InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:53:43 GMT20http://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspxIf 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. [url=http://www.mssqltips.com/sqlservertip/1294/listing-sql-server-object-dependencies/]Here's a great article from SQL Tip[/url]s that shows a ton of ways to get this done.Thu, 31 Jan 2013 06:20:47 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspx[quote][b]salmita (1/29/2013)[/b][hr]that's my question??? i don't know which ones can do the join ?[/quote]Well think about what you are asking. You are starting with knowing that you need customer and product information. You have that part down but think about what gets you from one to the other. What happens when a customer purchases something?Tue, 29 Jan 2013 12:36:25 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspxthat's my question??? i don't know which ones can do the join ?Tue, 29 Jan 2013 12:25:53 GMTsalmitahttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspx[quote][b]salmita (1/29/2013)[/b][hr]I wanna display the names of the customers along with the product names that they have purchased !![/quote]So what table(s) do you think you might need for this?Tue, 29 Jan 2013 12:20:26 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspxI wanna display the names of the customers along with the product names that they have purchased !!Tue, 29 Jan 2013 11:41:34 GMTsalmitahttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspx[quote][b]salmita (1/29/2013)[/b][hr]Hello,I am beginner in T-SQL.I need to find the tables to the join between the table "Product" table and the "Customer" of the database AdventureWorks2012.Any idea ? Thank you.[/quote]Customers have no direct tie to Products. Are you wanting to maybe see the Products that a customer has ordered?Tue, 29 Jan 2013 10:29:11 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1413151-3077-1.aspxHello,I am beginner in T-SQL.I need to find the tables to the join between the table "Product" table and the "Customer" of the database AdventureWorks2012.Any idea ? Thank you.Tue, 29 Jan 2013 09:39:02 GMTsalmita