Query comes back with errors

[Magic]

Hello Devbest,

When we run this code:

BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedBy
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
END

It comes back with errors, Any help on this?

 

[Matty2k7]

Meh, im tryna do a rp with LifeCMS and life cms relaity is so fucking shit, they got shit loads of errors

 

[Queef]

Meh, im tryna do a rp with LifeCMS and life cms relaity is so fucking shit, they got shit loads of errors

That is quite possibly the most off topic and irrelevant reply I've ever seen, how in the world does this help us figure out whats not right here?

Cheers Magic, hope we get the help needed.

 

[Magic]

We aren't even using LifeCMS

 

[Queef]

Never mind, figured out what i was doing wrong, its a procedure not a query. /Close thread.

 

[lepos]

Closed on request.