Results 1 to 2 of 2

Thread: querying

  1. #1
    Join Date
    Dec 1969

    Default querying

    Hi,<BR><BR>I have two tables Project_master(PROJECT_ID,PROJECT_NAME,PROJ_PRICE) and project_details(project_id,country_id).<BR><BR>Whi le displaying in my ASP page, though one project belongs to more than 1 country, I should display only once not more than that.<BR>When I use distinct while joining the 2 tables it is throwing all the records.<BR><BR>Pls suggest.

  2. #2
    Join Date
    Dec 1969

    Default AspFaqs.com, Databases General

    In there, there is a FAQ on displaying Categories and Subcategories.<BR><BR>It should give you a start.

Posting Permissions

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