Click here to Skip to main content
14,979,093 members
Home / Discussions / Database
   

Database

 
AnswerRe: joint Pin
S Douglas19-Aug-11 12:58
professionalS Douglas19-Aug-11 12:58 
AnswerRe: joint Pin
Ganu Sharma15-Sep-11 21:20
MemberGanu Sharma15-Sep-11 21:20 
QuestionCreate a trigger Pin
lionelcyril18-Aug-11 18:29
Memberlionelcyril18-Aug-11 18:29 
AnswerRe: Create a trigger Pin
Wendelius18-Aug-11 19:07
mveWendelius18-Aug-11 19:07 
GeneralRe: Create a trigger Pin
lionelcyril18-Aug-11 19:12
Memberlionelcyril18-Aug-11 19:12 
GeneralRe: Create a trigger Pin
Wendelius18-Aug-11 19:18
mveWendelius18-Aug-11 19:18 
AnswerRe: Create a trigger [modified] Pin
Shameel18-Aug-11 23:03
professionalShameel18-Aug-11 23:03 
QuestionSQL Query From Query Results Pin
Kyudos18-Aug-11 14:36
MemberKyudos18-Aug-11 14:36 
As always my SQL skills are limited and rusty. How does one accomplish this?

I have a 'Components' table. A 'Component' may be an assembly of other components. This is defined in the 'Assemblies' table.

Assemblies has columns : AssemblyKey / ItemKey / Quantity.

AssemblyKey identifies with Components.ComponentKey and is the ID of the assembly component.
ItemKey is the ComponentKey ID of the constituent component of the assembly
Quantity is the amount of ItemKey items in the assembly.

I want to list all the assemblies in the database, with all the components in each assembly.

Can I do that in one query?

(So

SELECT Components.Description, Assemblies.ItemKey FROM Assemblies, Components
WHERE Assemblies.`Assembly Key` = Components.`Component Key`


Gives me the assembly description and the IDs of the constituent components. I want to turn that resulting list of ItemKeys into descriptions from the Component table).
AnswerRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 15:04
professionalMycroft Holmes18-Aug-11 15:04 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 15:22
MemberKyudos18-Aug-11 15:22 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 18:34
MemberKyudos18-Aug-11 18:34 
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 20:38
professionalMycroft Holmes18-Aug-11 20:38 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 22:07
MemberKyudos18-Aug-11 22:07 
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 22:19
professionalMycroft Holmes18-Aug-11 22:19 
Questionplz brack my licence Pin
saqibali211918-Aug-11 8:08
Membersaqibali211918-Aug-11 8:08 
AnswerRe: plz brack my licence Pin
Mycroft Holmes18-Aug-11 20:41
professionalMycroft Holmes18-Aug-11 20:41 
QuestionCannot start MSSQLSERVER Pin
Blikkies17-Aug-11 22:02
professionalBlikkies17-Aug-11 22:02 
AnswerRe: Cannot start MSSQLSERVER Pin
Mycroft Holmes17-Aug-11 23:02
professionalMycroft Holmes17-Aug-11 23:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
GeneralRe: Cannot start MSSQLSERVER Pin
jschell18-Aug-11 12:56
Memberjschell18-Aug-11 12:56 
AnswerRe: Cannot start MSSQLSERVER Pin
Corporal Agarn18-Aug-11 2:02
professionalCorporal Agarn18-Aug-11 2:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
AnswerRe: Cannot start MSSQLSERVER Pin
Wendelius18-Aug-11 6:26
mveWendelius18-Aug-11 6:26 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 21:38
professionalBlikkies18-Aug-11 21:38 
QuestionOracle Collection Objects Pin
lionelcyril17-Aug-11 21:22
Memberlionelcyril17-Aug-11 21:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.