Click here to Skip to main content
15,798,200 members
Home / Discussions / Database
   

Database

 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:56
Member 115083508-Mar-15 17:56 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 18:18
Member 115083508-Mar-15 18:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 23:07
Chris Quinn8-Mar-15 23:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 7:51
Abdulnazark9-Mar-15 7:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 18:01
Member 115083509-Mar-15 18:01 
GeneralRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 22:06
Abdulnazark9-Mar-15 22:06 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:48
Member 115083509-Mar-15 17:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 18:59
Member 115083509-Mar-15 18:59 
SQL
SELECT COUNT(RESERVATION.GuestNo), GUEST.FirstName, RESERVATION.GuestNo

FROM GUEST INNER JOIN RESERVATION on GUEST.GuestNo = RESERVATION.GuestNo

GROUP BY GUEST.FirstName


I've tried this combination as well but Access tells me, You tried to execute a query that does not include the specified expression 'GuestNo' as part of an aggregate functio
QuestionVB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE28-Feb-15 23:01
KipkoechE28-Feb-15 23:01 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
manchanx1-Mar-15 2:01
professionalmanchanx1-Mar-15 2:01 
GeneralRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE3-Mar-15 20:48
KipkoechE3-Mar-15 20:48 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
Mycroft Holmes1-Mar-15 14:54
professionalMycroft Holmes1-Mar-15 14:54 
GeneralHow to increase SQL Query Performance for the Oracle Database Pin
Blog euth27-Feb-15 0:08
Blog euth27-Feb-15 0:08 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Jörgen Andersson27-Feb-15 0:37
professionalJörgen Andersson27-Feb-15 0:37 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Mycroft Holmes1-Mar-15 14:48
professionalMycroft Holmes1-Mar-15 14:48 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
PIEBALDconsult6-Mar-15 15:56
professionalPIEBALDconsult6-Mar-15 15:56 
QuestionDifficult Select Query Pin
Dimitris Sakellariou26-Feb-15 0:59
Dimitris Sakellariou26-Feb-15 0:59 
AnswerRe: Difficult Select Query Pin
Corporal Agarn26-Feb-15 1:56
professionalCorporal Agarn26-Feb-15 1:56 
AnswerRe: Difficult Select Query Pin
Abdulnazark9-Mar-15 9:49
Abdulnazark9-Mar-15 9:49 
QuestionDB Conversion Advice Pin
Kyudos25-Feb-15 12:00
Kyudos25-Feb-15 12:00 
GeneralRe: DB Conversion Advice Pin
PIEBALDconsult25-Feb-15 13:21
professionalPIEBALDconsult25-Feb-15 13:21 
AnswerRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 14:10
professionalMycroft Holmes25-Feb-15 14:10 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 15:38
Kyudos25-Feb-15 15:38 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 15:59
professionalMycroft Holmes25-Feb-15 15:59 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 16:05
professionalMycroft Holmes25-Feb-15 16:05 

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.