Click here to Skip to main content
15,395,473 members
Home / Discussions / Database
   

Database

 
AnswerRe: would you use RDLC? Pin
Mycroft Holmes18-Apr-14 13:33
professionalMycroft Holmes18-Apr-14 13:33 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 12:15
MemberJassim Rahma20-Apr-14 12:15 
GeneralRe: would you use RDLC? Pin
Mycroft Holmes20-Apr-14 12:54
professionalMycroft Holmes20-Apr-14 12:54 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 22:04
MemberJassim Rahma20-Apr-14 22:04 
QuestionOld school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 6:31
professionaljkirkerx17-Apr-14 6:31 
AnswerRe: Old school dbase II / clipper database, multiple left joins Pin
Jörgen Andersson17-Apr-14 10:38
professionalJörgen Andersson17-Apr-14 10:38 
General[SOLVED] Pin
jkirkerx17-Apr-14 10:49
professionaljkirkerx17-Apr-14 10:49 
GeneralRe: Old school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 11:03
professionaljkirkerx17-Apr-14 11:03 
That Works! Thanks Jorgen

SELECT  c.FINVNO
,c.FCUSTNO
,c.FCOMPANY
,c.FSALESPN
,c.FSHIPVIA
,c.FORDDATE
,c.FSHIPDATE
,c.FNTAXAMT
,(SELECT a.FADDR1 FROM ARCUS01.dbf a WHERE c.FCUSTNO = a.FCUSTNO) AS FADDR1
,(SELECT e.FEMAIL1 FROM ARCEM01.dbf e WHERE c.FCUSTNO = e.FCUSTNO) AS FEMAIL1
FROM ARINV01.dbf c
WHERE c.FORDDATE=@startDate

QuestionSQL Query Pin
Syafiqah Zahirah17-Apr-14 6:00
MemberSyafiqah Zahirah17-Apr-14 6:00 
AnswerRe: SQL Query Pin
Richard Deeming17-Apr-14 6:59
mveRichard Deeming17-Apr-14 6:59 
GeneralRe: SQL Query Pin
Syafiqah Zahirah17-Apr-14 20:18
MemberSyafiqah Zahirah17-Apr-14 20:18 
GeneralRe: SQL Query Pin
Richard Deeming22-Apr-14 2:28
mveRichard Deeming22-Apr-14 2:28 
QuestionWhy connection is failing?! Pin
Jassim Rahma16-Apr-14 9:59
MemberJassim Rahma16-Apr-14 9:59 
QuestionRe: Why connection is failing?! Pin
Eddy Vluggen16-Apr-14 10:43
professionalEddy Vluggen16-Apr-14 10:43 
AnswerRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 10:50
MemberJassim Rahma16-Apr-14 10:50 
GeneralRe: Why connection is failing?! Pin
Mycroft Holmes16-Apr-14 12:57
professionalMycroft Holmes16-Apr-14 12:57 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 12:59
MemberJassim Rahma16-Apr-14 12:59 
GeneralRe: Why connection is failing?! Pin
Bernhard Hiller16-Apr-14 20:54
MemberBernhard Hiller16-Apr-14 20:54 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 22:38
MemberJassim Rahma16-Apr-14 22:38 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 0:26
professionalEddy Vluggen17-Apr-14 0:26 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma17-Apr-14 0:42
MemberJassim Rahma17-Apr-14 0:42 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 10:46
professionalEddy Vluggen17-Apr-14 10:46 
Questionwhy looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 0:04
MemberJassim Rahma16-Apr-14 0:04 
AnswerRe: why looping is not starting from my start date? Pin
jimbowAX16-Apr-14 3:04
MemberjimbowAX16-Apr-14 3:04 
QuestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:01
mveRichard MacCutchan16-Apr-14 6:01 

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.