Dear All,
I am interested in performing a sub query that removes duplicate records from
a temporary table prior to pushing the data to the main table.
I am not sure if it is possible and thought I would ask prior to the endeavor.
I currently use php to perform this operation but is really bogs
MySQL Version 5.0.22
I would be thrilled if someone could even just point me to a site that
provided good examples of using sub queries. I have the following query:
SELECT
participants.store_id,
completed_modules.module_id,
AVG(completed_modules.score) AS AVGSCORE
FROM
: Wednesday, May 16, 2007 7:25 PM
Subject: Sub query help
MySQL Version 5.0.22
I would be thrilled if someone could even just point me to a site that
provided good examples of using sub queries. I have the following query:
SELECT
participants.store_id,
completed_modules.module_id,
AVG
Brian,
I think the answer is to create a sub query,
Without your tables I can't test this transcription, but the trick is
straightforward: if the first query includes the column(s) required to
join it correctly to the 2nd query, replace the avgscore table reference
in the second query with
Hello
I have written a report generator in PHP that handles creating and
paginating the results from queries into a nice, user-friendly, HTML
format. Because it's a generic report generator, it has some quirks
about it, but I have managed to modify queries enough so that it works
in almost all