Compare two values
Posted: Fri Jul 10, 2009 2:36 pm
Hello
I'm stuck on a query I'm putting together and I was hoping a fresh pair of eyes could help me see my mistake....
I have database with three tables = tour, user & brokerage
I'm to return the results of: All user tours for two different brokerage companies
This statement Works and returns the data for company one....how do i get results for company one& company two???
Working query
Attempted query
This attempt returns nothing.......
I'm stuck on a query I'm putting together and I was hoping a fresh pair of eyes could help me see my mistake....
I have database with three tables = tour, user & brokerage
I'm to return the results of: All user tours for two different brokerage companies
This statement Works and returns the data for company one....how do i get results for company one& company two???
Working query
Code: Select all
$sql = "SELECT * FROM tour LEFT JOIN user ON tour.userid=user.userid LEFT JOIN brokerage ON user.brokerageid = brokerage.brokerageid WHERE brokerage.brokerage = 'Company One' GROUP BY tour.userid ORDER BY brokerage.brokerageid ";Code: Select all
$sql = "SELECT * FROM tour LEFT JOIN user ON tour.userid=user.userid LEFT JOIN brokerage ON user.brokerageid = brokerage.brokerageid WHERE brokerage.brokerage = 'Company One' AND brokerage.brokerage = 'Company Two' GROUP BY tour.userid ORDER BY brokerage.brokerageid ";