mysql syntax error

Question

I'm trying to get values that equal both b.business_id = 22 and l.zip = 91326. The easiest thing for me to try was select l.*,b.name from buslocations AS l left join business as b where b.business_id = '22' and l.zip = '91326' but apparently there is something wrong with that. Any assistance with the correct syntax for two defined values would be appreciated.

dusoft · Accepted Answer · 2009-08-31 07:45:58Z

2

you need to match the tables by some key or value using ON such as:

select l.*,b.name from buslocations AS l left join business as b ON l.x=b.Y WHERE  b.business_id = '22' and l.zip = '91326'

answered Aug 31, 2009 at 7:45

dusoft

11.5k5 gold badges40 silver badges45 bronze badges

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

2 Comments

Ivan Novak Over a year ago

eek, I must be tired. Thanks.

Aaron Fi Over a year ago

...and dusoft wins the race. : )

Aaron Fi · Accepted Answer · 2009-08-31 07:47:32Z

1

Your join query needs to specify on which columns you're joining the two tables.

http://dev.mysql.com/doc/refman/5.0/en/join.html

answered Aug 31, 2009 at 7:47

Aaron Fi

10.5k14 gold badges70 silver badges93 bronze badges

Collectives™ on Stack Overflow

mysql syntax error

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related