Freelance Forum | Freelance Jobs » FreelanceGossip Website Development » Programming / Scripting / Coding Forum

[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

SQL is a standard language for accessing databases.

Our SQL tutorial will teach you how to use SQL to access and manipulate data in:

MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

SELECT Company, Country FROM Customers WHERE Country <> 'USA'

Hello. And Bye.

Magnificent website. Lots of useful info here. I am sending it to some pals ans additionally sharing in delicious. And certainly, thank you in your effort!

???! ????? ???? ????????????? ????? Call0fDiity17w ? ????? ?????!
?ea??! ?i??ea?e?? ?aa?a??u oi????a?? ei??a i?e?a???? au?i? e??u Call0fDiity17w ? ?ia?e?i ca e?oi??a?e?!
????? ?????!

hey there and thanks in your info – I’ve certainly picked up anything new from right here. I did on the other hand expertise several technical points the usage of this site, as I experienced to reload the web site many times prior to I could get it to load properly. I have been brooding about if your web host is OK? No longer that I am complaining, but sluggish loading instances instances will sometimes impact your placement in google and could damage your quality ranking if ads and *********** <a href=http://edubacklinksstore.com/>get edu backlinks</a>

äèåòè÷åñêèé ñóï èç øïèíàòàíëï-è ðàáîòà ñ ëèøíèì âåñîìóñêîðåííûé êóðñ ïîõóäåíèÿ â êëèíèêå ñàíêò-ïåòåðáóðãàïîõóäåòü ñ âëàäèìèðîì ñîëîâüåâûìïþñû è ìèíóñû ñðåäòçåìíîìîðñêîé äèåòû÷åì ïîìîãàåò ãðå÷íåàÿ äèåòàôèçêóëüòóðà è ëèøíèé âåñêàê ïîõóäåòü ïî íàðîäíûì ðåöåïòàìïîõóäåòü íà 5-7 êã çà ìåñÿöâ ÿïîíèè èçîáðåëè î÷êè äëÿ ïîõóäåíèÿñàìûå ïîïóëÿðíûå äèåòû îò à äî ÿêàêèå åñòü äèåòû ÷òîá óáðàòü ùåêèêàêîé âûáðàòü àíòèöåëëþëèòíûé êðåìäèåòû äëÿ ïîõóäåíèÿþïîõóäåíèå íà 10 êã çà ìåñÿöêòî ïîõóäåë ïî àëåííó êàððóóïðàæíåíèå äëÿ æèâîòà áûñòðî ïîõóäåòüäèåòû äëÿ äèòåéî÷èùåíèå îðãàíèçìà ÿïîíñêàÿ äèåòàñèíäðîì ìåëëîðè-âåñà äèåòàòåïëîèçîëÿöèîííûå ìàòåðèàëû êðåìëåâñêàÿ äèåòà

çîëîòàÿ ñåðüãà äëÿ ïîõóäåíèÿ ìåòðî ìîëîäåæíàÿëå÷åáíàÿ äèåòà äëÿ æåëóäêàî÷åíü ýôôåêòèâíàÿ äèåòàäèåòà 1ë ìîëîêà ÷åðíûé õëåáêàê ïîõóäåòü íà 40 êã çà 3 ìåñÿöàçàñòàâèòü ïîõóäåòüäèåòà àíèòà öîé ãðåéïôðóêòâèäåî-êóðñ äëÿ ïîõóäåíèÿ ïèëàòîñêàêóþ äèåòó ñîáëþäàòü ïðè ñàõàðíîì äèàáåòå âòîðîãî è ïåðâîãî òèïàäèåòè÷åñêîå ïèòàíèå ïðè ïàíêðèîòèòå ìÿñíûå êàòëåòû íà ïàðóäèåòà äîêòîðà õàñàíà èç ëàòâèèêàê ïîõóäåòü â áåäðàõ è ÿãîäèöàõöåíòð ïîõóäåíèÿ áîðìèíòàëüî÷èùåíèå æåíñêîãî îðãàíèçìà îò øëàêîâ ïîõóäåíèåñàíèòàðíûå ïðàâèëà òîðãîâëè ïðîäóêòàìè ïèòàíèÿ ïî ã.ïåòðîçàâîäñêóýôôåêòèâíàÿ äèåòà äëÿ ìóæ÷èí áåñïëàòíîïðàâèëüíîå äûõàíèå äëÿ ïîõóäåíèÿìàññàæíàÿ êðîâàòü äëÿ ïîõóäåíèÿäèåòà ïðè íåñòàáèëüíîñòè ïîçâîíî÷íèêàìîæíî ëè ïîõóäåòü íà îâîùàõ

ïðèêîëüíûé ó âàñ ôîðóì, çàöåíèë.