answersLogoWhite

0


Best Answer

select a.name, b.id, c. product

from user a

left outer join activities b

on a.user_id = b.user_id

left outer join products c

on b.product_id = c. pproduct_id

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Example for joining more than 3 tables using SQL server?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you use SQL?

You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.


How to have MS-SQL-Server Tables containing spaces and the character in their name in the FROM-clause using FreeTDS.?

Use the square brackets: for example a table named: "User Password" would be called [User Password] this also works when a table or a column has a keyword as a name Table ID is called using [ID]


How do you relate tables?

You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.


How do you related?

You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.


Feature of rdbms?

It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are also retrieved using SQL


Sentence using the plural word of affiliate?

no not like that like a sentence that has the word example in it like. 1x2 is an example of ur time tables


What are green server rooms?

Server rooms that attempt to be more energy efficient than standard server rooms, for example by using energy efficient components or using more natural cooling and less air conditioning.In addition a green server room might get its power from a "green" source like windmill or geothermal power.


Is a bukkit server dedicated?

Bukkit is a server managing program, not actually a server itself... You can have a server using Bukkit that's dedicated, On the other hand... you can have a server using Bukkit that isn't.


What are advantages when using a home server?

Using a home server can be more secure.You can secure your home server by putting a password on your server so no one can access your home server connection.


What is difference between database and database management system?

A database is a collection of tables which store information. A Database Management System is an application/environment for creating, modifying and administering any number of individual databases. For example: MSSQL databases are typically managed using MS SQL Server Management Studio MySQL databases are commonly managed using PHPMyAdmin


Is there anyway to tell if someone has logged into your email from a remote location?

yes, but depends on what kind of mail you are using and how its if configured on server, for example say you are using pop through web access and some one log in to the same account than you would get force log out.or in exchange server the mails will bounce vice-verse. yes, but depends on what kind of mail you are using and how its if configured on server, for example say you are using pop through web access and some one log in to the same account than you would get force log out.or in exchange server the mails will bounce vice-verse.


What is a MIPS server?

A server built using MIPS processors.