Click here to Skip to main content
12,398,225 members (57,808 online)
   

Database

 
QuestionHow to access window ? Pin
nghia09t317-Oct-12 5:27
membernghia09t317-Oct-12 5:27 
AnswerRe: How to access window ? Pin
Eddy Vluggen17-Oct-12 9:32
memberEddy Vluggen17-Oct-12 9:32 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 12:47
membernghia09t317-Oct-12 12:47 
AnswerRe: How to access window ? Pin
Richard Andrew x6417-Oct-12 14:06
memberRichard Andrew x6417-Oct-12 14:06 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 14:29
membernghia09t317-Oct-12 14:29 
QuestionDatabase to C++ Pin
shiftwik16-Oct-12 16:21
membershiftwik16-Oct-12 16:21 
AnswerRe: Database to C++ Pin
Jochen Arndt16-Oct-12 21:21
memberJochen Arndt16-Oct-12 21:21 
Questionsubquery using 1 table Pin
john john mackey16-Oct-12 7:26
memberjohn john mackey16-Oct-12 7:26 
i'm not sure if this is a Circular Reference problem or not.

i have the following SQL query
SELECT tb1.SomeField,
(SELECT tb2.AccountName
FROM tblAccountInfo tb2
WHERE tb2.CustomerID = tb1.CustomerID) AS strAccountName
FROM tblAccountInfo tb1
WHERE tb1.AccountID = 123456 

Since i'm using the same table in the subquery, is this a problem?

If it is a circular problem, how could i correct this?

Thanks,
JJ
AnswerRe: subquery using 1 table Pin
Marcus Kramer16-Oct-12 8:01
memberMarcus Kramer16-Oct-12 8:01 
GeneralRe: subquery using 1 table Pin
john john mackey16-Oct-12 9:50
memberjohn john mackey16-Oct-12 9:50 
AnswerRe: subquery using 1 table Pin
Michael Potter16-Oct-12 10:38
memberMichael Potter16-Oct-12 10:38 
AnswerRe: subquery using 1 table Pin
AspDotNetDev16-Oct-12 11:25
protectorAspDotNetDev16-Oct-12 11:25 
AnswerRe: subquery using 1 table Pin
Aadhar Joshi16-Oct-12 20:28
memberAadhar Joshi16-Oct-12 20:28 
GeneralRe: subquery using 1 table Pin
john john mackey17-Oct-12 4:38
memberjohn john mackey17-Oct-12 4:38 
QuestionHigh Number of Lock Requests Pin
cjb11016-Oct-12 3:23
membercjb11016-Oct-12 3:23 
AnswerRe: High Number of Lock Requests Pin
Eddy Vluggen17-Oct-12 0:17
memberEddy Vluggen17-Oct-12 0:17 
QuestionSQL Select Where query Pin
Joe Stansfield15-Oct-12 0:37
memberJoe Stansfield15-Oct-12 0:37 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 0:57
memberEddy Vluggen15-Oct-12 0:57 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:15
memberJoe Stansfield15-Oct-12 1:15 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:22
memberEddy Vluggen15-Oct-12 1:22 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:28
memberJoe Stansfield15-Oct-12 1:28 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 2:15
memberEddy Vluggen15-Oct-12 2:15 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 10:48
memberJoe Stansfield15-Oct-12 10:48 
GeneralRe: SQL Select Where query Pin
Marcus Kramer15-Oct-12 11:06
memberMarcus Kramer15-Oct-12 11:06 
GeneralRe: SQL Select Where query Pin
Joe Stansfield16-Oct-12 0:08
memberJoe Stansfield16-Oct-12 0:08 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 25 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid