Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help to build a Query
Message
From
25/10/2008 22:37:44
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Help to build a Query
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01357186
Message ID:
01357186
Views:
59
Hello, I have to build a query from 3 tables:

Table Usuarios:
IDusuario Nombre
1 Charles
2 George

Table ModAsg:
Codmodulo Idusuario
1 1
2 1
3 1
1 2


Table Modulos:
Cod Modulos
1 Mymodule1
2 Mymodule2
3 Mymodule3
4 Mymodule4

When I use this query:
Select Usuario.Nombre, Modulos.Modulo from Usuario, ModAsg, Modulos where Usuario.Idusuario=Modasg.idusuario and Modasg.codmodulo=Modulos.cod and Usuario.idusuario = 2

It displays:
George and Mymodule1

I need now to show for george the modules that he doesn't have yet, like
George and Mymodule2, Mymodule3, Mymodule4

How can i do it?
Next
Reply
Map
View

Click here to load this message in the networking platform