[itHighway]

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!

[web_doctor]

I saw your posts and your image, please try to write in your sql
SQL: "SELECT LS.* FROM tblListings LS, tblListingFloorPlans LFP WHERE LS.IngLIstingId=LFP.IngListingId AND LFP.txtBed='2' GROUP BYLFP.txtTitle"

If you want to sort your result in order basing on the LFP.txtTitle , just add ASC - for ASCending or DESC - for DESCending at the end of the query before the last diuble qoute, like this one.

SQL: "SELECT LS.* FROM tblListings LS, tblListingFloorPlans LFP WHERE LS.IngLIstingId=LFP.IngListingId AND LFP.txtBed='2' GROUP BY LFP.txtTitle ASC" ---> this will sort the result based on LFP.txtTitle in ASCending order

and another example is

SQL: "SELECT LS.* FROM tblListings LS, tblListingFloorPlans LFP WHERE LS.IngLIstingId=LFP.IngListingId AND LFP.txtBed='2' GROUP BY LFP.txtTitle DESC" ---> this will sort the result based on LFP.txtTitle in DESCending order

I hope this helps. Let me know. Thanks