answersLogoWhite

0

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

13y ago

What else can I help you with?

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 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 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 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.


How do you join tables in SQL?

In SQL, you join tables using the JOIN clause, which allows you to combine rows from two or more tables based on a related column. The most common types of joins are INNER JOIN, which returns rows with matching values in both tables; LEFT JOIN, which returns all rows from the left table and matched rows from the right table; and RIGHT JOIN, which does the opposite. You specify the joining condition using the ON keyword, typically comparing primary and foreign keys. For example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.foreign_id;.


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


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


How many round tables fit under a 40 x 40 tent?

The number of round tables that can fit under a 40 x 40 tent depends on the size of the tables. For example, if using standard 60-inch round tables, typically about 8-10 tables can fit comfortably, allowing for space for chairs and movement. If using smaller tables, more can fit, while larger tables will reduce the number. Always consider additional space needed for pathways and accessibility.


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.


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.


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.


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.