Click here to Skip to main content
15,113,873 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Interview Pin
Richard MacCutchan13-Apr-19 0:20
mveRichard MacCutchan13-Apr-19 0:20 
GeneralRe: SQL Interview Pin
Eddy Vluggen16-Apr-19 3:54
professionalEddy Vluggen16-Apr-19 3:54 
AnswerRe: SQL Interview Pin
#realJSOP16-Apr-19 3:00
mva#realJSOP16-Apr-19 3:00 
QuestionQuerying from multiple tables at the same time - related to correlated subqueries Pin
User 141845817-Apr-19 6:12
MemberUser 141845817-Apr-19 6:12 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
Mycroft Holmes7-Apr-19 13:08
professionalMycroft Holmes7-Apr-19 13:08 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
Eddy Vluggen8-Apr-19 1:44
professionalEddy Vluggen8-Apr-19 1:44 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
CHill6011-Apr-19 7:48
mveCHill6011-Apr-19 7:48 
QuestionHELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 18:37
MemberBrunoPigeon4-Apr-19 18:37 
Hi all. I have two tables in access (VB6): SupplierInvoices & Sales. They both have 3 common field names: Date, Code & Qty. I need to query both tables via SQL query by a specific date range as follows (I know this is wrong, but just to give you an idea):

rs.Open "Select distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, Sum(SupplierInvoices.QTY) as tTotal from SupplierInvoices, format(Sales.Date, 'dd-MMM-yyyy') as sDate, Sum(Sales.QTY) as sTotal from Sales where PLU = '" & lblPLU.Caption & "' and Date Between #" & StartTime & "# and #" & EndTime & "# Group by format(SupplierInvoices.Date, 'dd-MMM-yyyy');", cn, adOpenKeyset, adLockOptimistic

The result needs to return from both tables the sum of the qty fields for that date range. I can't get it right! Please help.
AnswerRe: HELP WITH SQL QUERY Pin
Mycroft Holmes4-Apr-19 21:38
professionalMycroft Holmes4-Apr-19 21:38 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 21:56
MemberBrunoPigeon4-Apr-19 21:56 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 22:06
professionalGuyThiebaut4-Apr-19 22:06 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 22:10
MemberBrunoPigeon4-Apr-19 22:10 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 22:20
professionalGuyThiebaut4-Apr-19 22:20 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 22:43
professionalGuyThiebaut4-Apr-19 22:43 
AnswerRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:56
professionalGuyThiebaut4-Apr-19 21:56 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 21:58
MemberBrunoPigeon4-Apr-19 21:58 
GeneralRe: HELP WITH SQL QUERY Pin
Mycroft Holmes4-Apr-19 22:16
professionalMycroft Holmes4-Apr-19 22:16 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 22:24
professionalGuyThiebaut4-Apr-19 22:24 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 1:13
MemberBrunoPigeon5-Apr-19 1:13 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 22:17
professionalGuyThiebaut4-Apr-19 22:17 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 1:11
MemberBrunoPigeon5-Apr-19 1:11 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut5-Apr-19 3:48
professionalGuyThiebaut5-Apr-19 3:48 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 5:22
MemberBrunoPigeon5-Apr-19 5:22 
QuestionIn Access: group of records and assign conditional group ? Pin
Member 245846726-Mar-19 23:18
MemberMember 245846726-Mar-19 23:18 
AnswerRe: In Access: group of records and assign conditional group ? Pin
Victor Nijegorodov27-Mar-19 12:50
MemberVictor Nijegorodov27-Mar-19 12:50 

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.