SQL and Joining Tables

Results 1 to 2 of 2

Thread: SQL and Joining Tables

  1. #1
    Join Date
    Dec 1969

    Default SQL and Joining Tables

    sql = "select TblLunch.lunchTimes, Users.FirstName, users.lastName "&_<BR> "from TblLunch, Users, lunchTimes "&_<BR> "where TblLunch.lunchHour = lunchTime.lunchTimeID and "&_<BR> "users.UserID = TblLunch.userID and"&_<BR> "TblLunch.LunchDate ="& lunchDate %&#062;<BR><BR>This is my SQL statment, my delima is how do i show the results from the different tables...<BR>would this work: "&#060;%=objRS("lunchTimes")%&#062;" To show the lunch times<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL and Joining Tables

    that&#039;s not a joined statement. but yes, lunchTimes OUGHT to do it, if the SQL executes without 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