Click here to Skip to main content
15,904,652 members
Home / Discussions / Database
   

Database

 
GeneralRe: Server Explorer Error Pin
Rob Graham25-Oct-03 5:49
Rob Graham25-Oct-03 5:49 
QuestionIf it is a bug? Pin
TPN20-Oct-03 23:17
TPN20-Oct-03 23:17 
AnswerRe: If it is a bug? Pin
Terry O'Nolley25-Oct-03 15:07
Terry O'Nolley25-Oct-03 15:07 
GeneralGroup by Pin
Anonymous20-Oct-03 7:06
Anonymous20-Oct-03 7:06 
GeneralRe: Group by Pin
Chris Meech20-Oct-03 8:00
Chris Meech20-Oct-03 8:00 
GeneralMultiple SOMETHING in DataGrid Pin
Cirrus200019-Oct-03 21:00
Cirrus200019-Oct-03 21:00 
GeneralRe: Multiple SOMETHING in DataGrid Pin
Guillermo Rivero20-Oct-03 3:59
Guillermo Rivero20-Oct-03 3:59 
GeneralRe: Multiple SOMETHING in DataGrid Pin
Cirrus200020-Oct-03 10:19
Cirrus200020-Oct-03 10:19 
Sheesh. Query. Thanks, Guillermo.

I went into Access, and designed a query. Of course, I didn't realize you could put more than one copy of the same table into the query builder!

Came out with a SQL statement like this:

SELECT Mbr.MbrId, Mbr.LastName, Mbr.FirstName, Mbr.UpdDt, Mbr_1.LastName, Mbr_1.FirstName<br />
FROM Mbr INNER JOIN Mbr AS Mbr_1 ON Mbr.UpdLogin = Mbr_1.MbrId<br />
ORDER BY Mbr.UpdDt DESC;


Well, yeah!D'Oh! | :doh:

Very embarassed now. Going to quietly read some more books, and experiment...

Thanks again!

Kevin Swanson
GeneralComplex DataBinding, advice required Pin
Anonymous18-Oct-03 7:15
Anonymous18-Oct-03 7:15 
QuestionIDENTITY COLUMN QUESTION??? Pin
mittalpa18-Oct-03 4:45
mittalpa18-Oct-03 4:45 
AnswerRe: IDENTITY COLUMN QUESTION??? Pin
andyharman20-Oct-03 11:53
professionalandyharman20-Oct-03 11:53 
GeneralRe: IDENTITY COLUMN QUESTION??? Pin
mittalpa21-Oct-03 4:42
mittalpa21-Oct-03 4:42 
GeneralEmbedded Query Pin
Chris Meech17-Oct-03 9:04
Chris Meech17-Oct-03 9:04 
GeneralRe: Solution Pin
Chris Meech20-Oct-03 4:59
Chris Meech20-Oct-03 4:59 
GeneralServer link Pin
Anonymous17-Oct-03 4:55
Anonymous17-Oct-03 4:55 
GeneralRe: Server link Pin
Colin Angus Mackay17-Oct-03 6:21
Colin Angus Mackay17-Oct-03 6:21 
GeneralVB.NET datagrid Pin
Anonymous16-Oct-03 12:30
Anonymous16-Oct-03 12:30 
GeneralRe: VB.NET datagrid Pin
Edbert P16-Oct-03 20:15
Edbert P16-Oct-03 20:15 
GeneralADO+&quot;Update&quot;+RecordsAffected+&quot;VC++&quot; Pin
DaviziN16-Oct-03 5:31
DaviziN16-Oct-03 5:31 
GeneralRe: ADO+&quot;Update&quot;+RecordsAffected+&quot;VC++&quot; Pin
DaviziN16-Oct-03 21:37
DaviziN16-Oct-03 21:37 
GeneralSome SQL problem in displaying data Pin
erbest15-Oct-03 22:20
erbest15-Oct-03 22:20 
GeneralRe: Some SQL problem in displaying data Pin
andyharman20-Oct-03 12:14
professionalandyharman20-Oct-03 12:14 
GeneralALTER TABLE ALTER COLUMN IDENTITY,help me Pin
crodling15-Oct-03 21:52
crodling15-Oct-03 21:52 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Mike Dimmick16-Oct-03 5:03
Mike Dimmick16-Oct-03 5:03 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Anonymous19-Oct-03 14:55
Anonymous19-Oct-03 14:55 

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.