| 00:05.57 | influx | So, I'm trying to join some information to the result set of a query, how might I do that? |
| 00:06.10 | influx | I'm thinking an inner join would do the trick. |
| 00:09.25 | influx | http://pastebin.com/AXNC5NHK |
| 00:09.40 | influx | To that, I want to join... |
| 00:12.38 | DexterTheDragon | influx: SELECT orders_id, products_id, SUM(products_quantity) AS products_quantity FROM orders_products JOIN orders on (orders_id=orders.id) WHERE date_purchased BETWEEN '2011-03-01' AND '2011-04-01' GROUP BY products_id |
| 00:12.47 | DexterTheDragon | I think that works |
| 00:15.14 | influx | Sorry. I didn't have the forethought to assemble the other result set before asking, so I'm still working on that half. |
| 00:24.06 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 00:29.37 | influx | Ack. I have to leave. |
| 00:29.44 | influx | I'll re-ask tomorrow. |
| 00:29.47 | influx | err, monday. |
| 00:34.06 | *** part/#uphpu mgeary (~mgeary@166.70.44.49) |
| 01:42.06 | *** join/#uphpu _psychic_ (~johnander@raisinbread.fttp.xmission.com) |
| 01:42.06 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 02:15.33 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 02:47.30 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 02:47.32 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 02:52.23 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 02:53.04 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 03:25.06 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 04:27.12 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 04:57.49 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 04:57.49 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 05:03.01 | josephscott | $chuck-fact |
| 05:03.01 | raifbot | Chuck Norrisâ roundhouse kick is so powerful, it can be seen from outer space by the naked eye. |
| 05:20.45 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 05:20.46 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 05:24.20 | josephscott | $rlart |
| 05:24.20 | raifbot | takes out a seltzer bottle and sprays Heartsbane in the face. You know, one of those old-school seltzer bottles clowns have? Yeah those. Anyway, consider yourself spritzed. |
| 05:39.55 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 05:39.55 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:25.16 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 15:25.16 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 16:10.11 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 16:11.49 | ninnypants1 | $chuck-fact |
| 16:11.49 | raifbot | Chuck Norris CAN believe it's not butter |
| 17:17.27 | *** join/#uphpu ninnypants1 (~ninnypant@209.63.213.199) |
| 17:42.23 | ninnypants1 | $chuck-fact |
| 17:42.24 | raifbot | When Neil Armstrong stepped on the moon, the first thing he saw was 'Chuck Norris was here' carved into a moon rock. |
| 17:53.59 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 18:11.16 | herlo | ninnypants1: you need to ghost your other user :) |
| 18:11.48 | ninnypants1 | herlo: it's my desktop at home |
| 18:17.34 | herlo | oh |
| 18:17.56 | herlo | ninnypants1: maybe an ircproxy (or irssi) is in your future :) |
| 18:22.10 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 18:29.59 | *** join/#uphpu kingsol (~kingsol@c-24-10-145-67.hsd1.ut.comcast.net) |
| 20:09.07 | *** join/#uphpu mastergunns (~mastergun@c-174-52-59-4.hsd1.ut.comcast.net) |
| 20:12.21 | *** join/#uphpu brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 20:12.21 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 20:35.03 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 21:08.07 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 21:08.07 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 21:38.23 | *** join/#uphpu mastergunns (~mastergun@c-174-52-59-4.hsd1.ut.comcast.net) |
| 21:38.27 | *** part/#uphpu mastergunns (~mastergun@c-174-52-59-4.hsd1.ut.comcast.net) |
| 22:42.06 | *** join/#uphpu kingsol (~kingsol@c-24-10-145-67.hsd1.ut.comcast.net) |
| 23:04.33 | *** join/#uphpu Heartsbane (tsharpe@unaffiliated/heartsbane) |
| 23:04.33 | *** mode/#UPHPU [+v Heartsbane] by ChanServ |
| 23:09.05 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 23:29.23 | *** join/#uphpu redroy1 (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 23:37.07 | *** join/#uphpu kingsol (~kingsol@c-24-10-145-67.hsd1.ut.comcast.net) |
| 23:41.39 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |