Click here to Skip to main content
14,391,105 members
   

Database

 
QuestionNeed help mixing two queries in one... Pin
Joan M1-Sep-19 1:40
professionalJoan M1-Sep-19 1:40 
AnswerRe: Need help mixing two queries in one... Pin
Richard Deeming2-Sep-19 2:02
communityengineerRichard Deeming2-Sep-19 2:02 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 2:39
professionalJörgen Andersson2-Sep-19 2:39 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 11:24
professionalJoan M2-Sep-19 11:24 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 20:27
professionalJörgen Andersson2-Sep-19 20:27 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 20:29
professionalJoan M2-Sep-19 20:29 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 20:35
professionalJörgen Andersson2-Sep-19 20:35 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 11:21
professionalJoan M2-Sep-19 11:21 
First of all thank you very much for your answer!

PHPMyAdmin doesn't know the word "WITH"... Dead | X|

Can't even try it...

I'm trying to avoid the need to do two queries while populating a table...

Would it be a bad design to add that totalInvoicePrice into the table tInvoices? that way at the moment of creating the invoice I would do what it's working now... and when I would need to get the data it would be extremely easy...
www.robotecnik.com[^] - robots, CNC and PLC programming

GeneralRe: Need help mixing two queries in one... Pin
phil.o2-Sep-19 11:43
mvephil.o2-Sep-19 11:43 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 12:24
professionalJoan M2-Sep-19 12:24 
GeneralRe: Need help mixing two queries in one... Pin
phil.o2-Sep-19 13:25
mvephil.o2-Sep-19 13:25 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 19:52
professionalJoan M2-Sep-19 19:52 
GeneralRe: Need help mixing two queries in one... Pin
Mycroft Holmes3-Sep-19 13:40
MemberMycroft Holmes3-Sep-19 13:40 
GeneralRe: Need help mixing two queries in one... Pin
Joan M4-Sep-19 10:24
professionalJoan M4-Sep-19 10:24 
GeneralRe: Need help mixing two queries in one... Pin
Joan M4-Sep-19 10:25
professionalJoan M4-Sep-19 10:25 
GeneralRe: Need help mixing two queries in one... Pin
Mycroft Holmes4-Sep-19 13:37
MemberMycroft Holmes4-Sep-19 13:37 
GeneralRe: Need help mixing two queries in one... Pin
Mycroft Holmes2-Sep-19 13:31
MemberMycroft Holmes2-Sep-19 13:31 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 20:27
professionalJoan M2-Sep-19 20:27 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 20:29
professionalJörgen Andersson2-Sep-19 20:29 
AnswerMessage Closed Pin
16-Sep-19 21:25
Membergentorify16-Sep-19 21:25 
QuestionAdvice or opinion on database planning for Angular using MongoDB and perhaps a 2nd technology. Pin
jkirkerx30-Aug-19 9:16
professionaljkirkerx30-Aug-19 9:16 
AnswerRe: Advice or opinion on database planning for Angular using MongoDB and perhaps a 2nd technology. Pin
Afzaal Ahmad Zeeshan30-Aug-19 12:56
mvaAfzaal Ahmad Zeeshan30-Aug-19 12:56 
GeneralRe: Advice or opinion on database planning for Angular using MongoDB and perhaps a 2nd technology. Pin
jkirkerx1-Sep-19 11:46
professionaljkirkerx1-Sep-19 11:46 
QuestionCompact and Repair Access Database using C# ? Pin
Member 245846729-Aug-19 16:14
MemberMember 245846729-Aug-19 16:14 
AnswerRe: Compact and Repair Access Database using C# ? Pin
Victor Nijegorodov29-Aug-19 21:37
MemberVictor Nijegorodov29-Aug-19 21:37 

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.