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

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


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.


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.


What is a MIPS server?

A server built using MIPS processors.


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.


How do you host a Halo CE server with your foreign IP address not your local 192 one?

Most routers (even home routers) have a feature known as port forwarding; you set the ports for Halo to forward to your 192 based server. The net result is that external users are routed to your server by using an external IP address and don't know that this is happening. For example, if a game or an application uses port 5000 to communicate with the server, set port 5000 to the 192.168 address of your server. If your external IP address for the router is (for example) 31.44.55.66, then users can get to your server by using the 31 address, but packets for the game will be routed to your 192.168 server which is internal.