November 7th, 2012, 10:11 PM
Query multible tables get one result
I have a query I need some help with.
Select * from users, mood where users.mood = mood.id
This will return all rows where the criteria are meet.
But instead of returning all rows I want to be able to do the same operation where the query is also limited by users.name
adding & users.name = 'test' to the query did not work very well
Does anyone know how to tacle this?
November 8th, 2012, 02:54 AM
that's because "&" isn't valid sql
try using AND instead
November 8th, 2012, 07:48 AM
your a sweetheart
Originally Posted by r937
November 8th, 2012, 07:54 AM