Jump to content

Sql Query

Whether you're a seasoned veteran or a struggling beginner, Web Radiance is the web development and web design forum for you. You'll find answers to all your HTML, CSS, SEO, and Programming needs. Pull up a chair and stay awhile.

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

Sql Query Rate Topic: -----

#1 User is offline   ECommerce Guru 

  • W.R. Private
  • Group: Members
  • Posts: 11
  • Joined: 11-January 08
  • Gender:Male
  • Location:GUJ
  • Interests:web development, web design, reading & writing web related articles, horse riding, swimming.

Posted 15 March 2008 - 02:41 PM

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.it...ad/sqlQuery.gif


Thanks!
================================================
Zeeshan Dar
itHighway
web design development custom e-commerce solution & web based real estate listings software services provider
0

#2 User is offline   Karl Buckland 

  • A.K.A. Sirkent
  • Group: Administrators
  • Posts: 2,145
  • Joined: 04-April 06
  • Gender:Male
  • Location:Kent, UK

Posted 16 March 2008 - 05:10 AM

Well, if you know there will only be one entry per id in the other table, then do AND LS.INGListingID=2. Alternatively, look at using the DISTINCT keyword.
QUOTE(benbramz @ Aug 17 2007, 07:44 AM) Ive noticed that quite a few people are now adding quotes from the board into their signature. I think its started an new web-radiance craze.. :P
0

#3 User is offline   EncoderDecoder 

  • W.R. Sergeant
  • Group: Members
  • Posts: 260
  • Joined: 01-March 11
  • Gender:Female
  • Location:Philippines

Posted 05 May 2011 - 09:38 AM

is this solved already..? can't access the link..
Custom Web Design
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users