LEFT JOIN query MYSQL does not work

Question

I have 2 tables rtz_order and rtz_restaurant

From order I want purchaseprice from restaurant i want "restaurant_commission" both have a column called restaurant_id So i want to join these to tables and add the restaurant_commission tot the query. I have come up with this (the date part etc works, i was already using that but the query does not work since I added the join)

$sql = 'SELECT order.orderpurchase, order.orderdate, order.status, order.restaurant_id, res.restaurant_commission, res.restaurant_id FROM rt_order order LEFT JOIN rt_restaurant res ON order.restaurant_id = res.restaurant_id WHERE date(order.orderdate) >= date(?) AND date(order.orderdate) <= date(?) AND order.restaurant_id = ? AND order.status = "completed"';

I have tried diffrent things but i do not see why this is going wrong

What's going wrong? Can you supply some sample data, the result you'd expect and the result you're actually getting? — Mureinik
– Mureinik, Commented May 1, 2014 at 17:30
@Zefnus If you're going to spam a million tag edits into the system, please take the time to fix all the problems with the questions — user229044
– user229044 ♦, Commented Jun 11, 2014 at 17:33

Brandon · Accepted Answer · 2014-05-01 17:36:58Z

2

ORDER is a reserved keyword.

Use backtics like:

`ORDER`

Check the complete list of reserved keywords here.

NOTE : It is better to avoid reserved keywords for column names, but if you use then wrap them with backtics.

edited May 1, 2014 at 17:36

Brandon

6435 silver badges13 bronze badges

answered May 1, 2014 at 17:29

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Reza Over a year ago

ahh,, yes... changed it to just "o" ..it works thanks!

Funk Forty Niner · Accepted Answer · 2014-05-23 15:24:34Z

1

Your alias order is a MySQL reserved word.

Make it either `order` using backticks, or change the alias' name.

edited May 23, 2014 at 15:24

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered May 1, 2014 at 17:30

iMakeWebsites

5873 silver badges10 bronze badges

Collectives™ on Stack Overflow

LEFT JOIN query MYSQL does not work

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related