Detail Page query...

Results 1 to 2 of 2

Thread: Detail Page query...

  1. #1
    Join Date
    Dec 1969

    Default Detail Page query...

    SELECT expiry, [tblEpisodic].[fprogram], [tblSchedule].[fprogram], fepisode, fgeneric, fprogram, fsynopsis, ftitle FROM tblEpisodic INNER JOIN tblSchedule ON [tblSchedule].[fepisode] = [tblEpisodic].[fepisode] WHERE [tblEpisodic].[fprogram] = ? ORDER BY fdate ASC <BR><BR>I get error:<BR><BR>System.Data.OleDb.OleDbException: The specified field &#039;fepisode&#039; could refer to more than one table listed in the FROM clause of your SQL statement.

  2. #2
    Join Date
    Dec 1969
    Indianapolis, IN

    Default RE: Detail Page query...

    So instead of simply fepisode in your SELECT clause, you need either tblEpisodic.fepisode or tblSchedule.fepisode, depending on which table you want to look at. Look at how you did your JOIN and mimic that. The query doesn&#039;t know which table to look at for the value, so it spit out the error.

Posting Permissions

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