Click here to Skip to main content
15,850,548 members
Home / Discussions / Database
   

Database

 
QuestionTwo Instances Of SQL Server??? Pin
AmbiguousName4-Feb-10 5:23
AmbiguousName4-Feb-10 5:23 
AnswerRe: Two Instances Of SQL Server??? Pin
David Mujica4-Feb-10 6:08
David Mujica4-Feb-10 6:08 
GeneralRe: Two Instances Of SQL Server??? Pin
AmbiguousName4-Feb-10 7:36
AmbiguousName4-Feb-10 7:36 
AnswerRe: Two Instances Of SQL Server??? Pin
debrah.h484-Feb-10 20:43
debrah.h484-Feb-10 20:43 
GeneralRe: Two Instances Of SQL Server??? Pin
Mycroft Holmes4-Feb-10 21:41
professionalMycroft Holmes4-Feb-10 21:41 
QuestionQuery Analyser 'responce time' Pin
cjb1104-Feb-10 1:18
cjb1104-Feb-10 1:18 
AnswerRe: Query Analyser 'responce time' Pin
Corporal Agarn4-Feb-10 1:49
professionalCorporal Agarn4-Feb-10 1:49 
QuestionSQL Join Problem Pin
Nishad4-Feb-10 0:05
Nishad4-Feb-10 0:05 
Hi I have 2 tables Table A and Table B



I want to join these tables.

The relation between these tables is RegNo

The first table stores the Trudent details and second table is a history table

The regNo in the first table is primary key and second table is forign key

I want to Join all the data in the these two tables based on Date and Last updated time
I want the result like the following

pls help me to find a soln

RegNo Name Class Date
12ABC ABC 10 3/2/2010
13ABC DCB 1 3/2/2010
14DFG DFG 12 3/2/2010
15FHG FHG 5 3/2/2010
16RTY RTY 8 3/3/2010

Table B
Id RegNo LastUpdated
1 12ABC 3/2/2010 12:30
2 12ABC 3/2/2010 13:00
3 12ABC 3/2/2010 16:00
4 13BC 3/2/2010 12:00

Result
RegNo Name Class LastUpdated
12ABC ABC 10 3/2/2010 16:00
13ABC DCB 1 3/2/2010 12:00
14DFG DFG 12 NULL
15FHG FHG 5 NULL
AnswerRe: SQL Join Problem Pin
Mycroft Holmes4-Feb-10 0:13
professionalMycroft Holmes4-Feb-10 0:13 
AnswerRe: SQL Join Problem Pin
Pranay Rana4-Feb-10 0:52
professionalPranay Rana4-Feb-10 0:52 
AnswerRe: SQL Join Problem Pin
masoumeh201010-Feb-10 19:29
masoumeh201010-Feb-10 19:29 
QuestionPL-SQL question, how to re-assign a value according to existing values Pin
alexyxj3-Feb-10 12:31
alexyxj3-Feb-10 12:31 
AnswerRe: PL-SQL question, how to re-assign a value according to existing values Pin
Mycroft Holmes3-Feb-10 13:17
professionalMycroft Holmes3-Feb-10 13:17 
GeneralRe: PL-SQL question, how to re-assign a value according to existing values Pin
alexyxj3-Feb-10 13:48
alexyxj3-Feb-10 13:48 
QuestionSQl Query Pin
Abdul Rahman Hamidy3-Feb-10 0:31
Abdul Rahman Hamidy3-Feb-10 0:31 
AnswerRe: SQl Query Pin
Blue_Boy3-Feb-10 0:39
Blue_Boy3-Feb-10 0:39 
GeneralRe: SQl Query Pin
Abdul Rahman Hamidy3-Feb-10 1:05
Abdul Rahman Hamidy3-Feb-10 1:05 
AnswerRe: SQl Query Pin
Pranay Rana3-Feb-10 0:59
professionalPranay Rana3-Feb-10 0:59 
GeneralRe: SQl Query Pin
J4amieC3-Feb-10 5:23
J4amieC3-Feb-10 5:23 
GeneralRe: SQl Query Pin
Pranay Rana3-Feb-10 20:03
professionalPranay Rana3-Feb-10 20:03 
GeneralRe: SQl Query Pin
J4amieC4-Feb-10 1:28
J4amieC4-Feb-10 1:28 
AnswerRe: SQl Query Pin
AprNgp7-Feb-10 7:04
AprNgp7-Feb-10 7:04 
GeneralRe: SQl Query Pin
Abdul Rahman Hamidy8-Feb-10 19:01
Abdul Rahman Hamidy8-Feb-10 19:01 
GeneralRe: SQl Query Pin
AprNgp9-Feb-10 4:38
AprNgp9-Feb-10 4:38 
Questionsql temp table Pin
jashimu2-Feb-10 9:43
jashimu2-Feb-10 9:43 

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.