what's wrong in this query?

Results 1 to 2 of 2

Thread: what's wrong in this query?

  1. #1
    Join Date
    Dec 1969

    Default what's wrong in this query?

    Hi Everyone,<BR><BR> Can anyone figure out what&#039s wrong in the following query:<BR><BR> Select distinct A.fldListingNumber,fldPropertyAddress,fldPropertyC ity,fldPropertyCounty,fldPropertyState,fldProperty Zip,fldListingExpiration,fldStatus,fldImage<BR> from tblSellerListings A,tblSellerListingImages B where A.fldListingNumber=B.fldListingNumber order by A.fldListingNumber<BR><BR> Though I have put the keyword "distinct" in the above query, it gives me duplicate set of records. <BR><BR> how to prevent the duplication?<BR><BR>Thanks,<BR>Anu.

  2. #2
    Join Date
    Dec 1969

    Default RE: what's wrong in this query?

    If you were to include an ORDER BY A.fldListingNumber in your query, you might get duplicate records even using the DISTINCT<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts