Getting error No. 1064... Deleting from multiple tables

[aalmakto]

Hi all,

Whats wrong with this syntax?

DELETE from fighterSponsor fs, sponsors s, imageData id where fs.sponsorId=s.sponsorId AND id.imageId=s.imageId AND (s.imageId=81 OR s.imageId=82)

I keep getting errors:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where fs.sponsorId=s.sponsorId AND id.imageId=s.imageId AND (s.imageId=81 OR s.i' at line 1

Thanks

Al

[pbmods]

Heya, Al.

When you DELETE from multiple tables, you must also specify which tables you are deleting from:

DELETE
        `fs`.*,
        `s`.*,
        `id`.*
    FROM
    (
            `fighterSponsor`
                AS `fs`
        INNER JOIN
            `sponsors`
                AS `s`
        INNER JOIN
            `imageData`
                AS `id`
    )
    WHERE
    (
            `fs`.`sponsorId` = `s`.`sponsorId`
        AND
            `id`.`imageId` = `s`.`imageId`
        AND
        (
                `s`.`imageId` = 81
            OR
                `s`.`imageId` = 82
        )
    )
 

[mwasif]

Moved to MySQL forum.

[aalmakto]

Heya, Al.

When you DELETE from multiple tables, you must also specify which tables you are deleting from:

DELETE
        `fs`.*,
        `s`.*,
        `id`.*
    FROM
    (
            `fighterSponsor`
                AS `fs`
        INNER JOIN
            `sponsors`
                AS `s`
        INNER JOIN
            `imageData`
                AS `id`
    )
    WHERE
    (
            `fs`.`sponsorId` = `s`.`sponsorId`
        AND
            `id`.`imageId` = `s`.`imageId`
        AND
        (
                `s`.`imageId` = 81
            OR
                `s`.`imageId` = 82
        )
    )
 

Worked like a charm!

Thanks

[pbmods]

Heya, Al.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)