Hello,
You can use the next SQL query:
| Code: |
DELETE FROM
jos_ariquizstatistics,
jos_ariquizstatisticsinfo
USING
jos_ariquizstatisticsinfo LEFT JOIN jos_ariquizstatistics
ON jos_ariquizstatisticsinfo.StatisticsInfoId = jos_ariquizstatistics.StatisticsInfoId
WHERE
jos_ariquizstatisticsinfo.StatisticsInfoId = STATISTICS_INFO_ID
|
Where STATISTICS_INFO_ID is ID of necessary results. For example if ID equals to 3, use the next query:
| Code: |
DELETE FROM
jos_ariquizstatistics,
jos_ariquizstatisticsinfo
USING
jos_ariquizstatisticsinfo LEFT JOIN jos_ariquizstatistics
ON jos_ariquizstatisticsinfo.StatisticsInfoId = jos_ariquizstatistics.StatisticsInfoId
WHERE
jos_ariquizstatisticsinfo.StatisticsInfoId = 3
|
Regards,
ARI Soft
