When I try to do this one thing to my db.

[Donutman123]

when i try to execute JulainX shopping mall i get some error saying [Err] 1054 - Unknown column 'vendorGuid' in 'where clause' [Msg] Finished - Unsuccessfully

[warsheep]

Ok, instead of giving you the answer, we'll do this the hard way.
Open your vendors table, and look there. What table do you think it could be instead? Open in notepad, look over it, and try to find it yourself.

[Donutman123]

now it says table n.vendors doesnt exist.