Sql Query

I need help with a sql query. To make it easier to understand I

created an image. Please click on link below to see the image.

http://realestate.ithighway.co.uk/upload/sqlQuery.gif


Thanks!

Try this dude, should work fine...

SELECT *
FROM tblListings, tblListingsFloorPlan
WHERE tblListings.IngListingId = tblListingsFloorPlan.IngListingId
AND tblListingsFloorPlan.txtBath = '2'

Problem was, you were not using an INNER join correctly.

Ps. 'I used MYSQL Meistro' myself and would say I learnt more from doing it myself...

You could change the '2' to a form field selected by the user if you wish.

Let me know if you need more help...

Paul

or
if txtBed is an integer field it shouldn't be in quotation marks ... but mrbigdog's looks as if it would work aswell ... try his first seeing that it's shorter ... otherwise try mine ... I just did it straight out of my head, so there might be some spelling mistakes or something like that ... also on mine try changing the "LEFT JOIN" to a "RIGHT JOIN" or an "INNER JOIN" if it doesn't work straight off ...

If you're not using a MySQL version prior to MySQL 5.0.12



If you get an error about an txtBed being an ambiguous column, you're using a version prior to 5.0.12