Click here to Skip to main content
14,980,532 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 15:04
professionalMycroft Holmes18-Aug-11 15:04 
My understanding is that you have only 2 levels, Assembly and child items called components.

It does seem weird that you would call the component foreign key to the assembly table ComponentKey the Component table should have a primary key ComponentKey and a foreign key AssemblyKey.

Select *
From Assembly A
 left join Components C on C.ComponentKey = A.AssemblyKey


This will give you all the assemblies even if there are no components.
Never underestimate the power of human stupidity
RAH

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 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:10
mveWendelius18-Aug-11 8:10 

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.