SQL query Problems

Results 1 to 2 of 2

Thread: SQL query Problems

  1. #1
    Join Date
    Dec 1969

    Default SQL query Problems

    Hey all-<BR>I&#039;m working on an asp page that displays a list of records with data culled from many tables. The DB is an access DB. If I use the query "Select * From Probrec", it pulls the data fine for the page. However, when I try to add some JOINs in using this query :<BR>"SELECT DISTINCTROW [Probrec].[KeyID], [Probrec].[Topic], [Probrec].[ReportedBy], [Probrec].[ReportedDate], [Agency].[AgencyName], [Category].[Category], [Pri].[PriDesc], [Status].[Status]<BR>FROM Status INNER JOIN (Pri INNER JOIN (Category INNER JOIN (Agency INNER JOIN Probrec ON [Agency].[AgencyID] =[Probrec].[AgencyID]) ON [Category].[CategoryID]<BR>=[Probrec].[CategoryID]) ON [Pri].[PriID] =[Probrec].[PriorityID]) ON [Status].[StatusID] =[Probrec].[StatusID]" <BR><BR>It doesn&#039;t work in asp, but works great in Access. Any Ideas why this might be?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL query Problems

    What is the error you are getting?<BR><BR>-Doug

Posting Permissions

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