Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
combining queries/subqueries
I have two queries I'd like to combine - and the json is kicking my butt. The json extract below pulls a sku out of a lookup table along with the quantity ordered {"9999":2} It works fine. If I add the 3 commented out portions, I get no results. SELECT `p`.`id`, `p`.`sku`... -
return groupod by dates from subquery
Here's the logic I am atempting to apply Have a base_orders table. It contains order_date and completed (shipped) The first part is I needed to know the number of orders that were received and shipped out on the same day, for a range of days (a week for example) Someone was nice enough to... -
subqueries with multiple date results
subqueries with multiple date results I am building a query that shows the number of orders received, on each date within a range of dates Wanted: a 2nd column of orders that were shipped in full on the same day they were received. this is what I have so far, and the results of orders in...
