Re: Query in Joining 4 tables

Re: Query in Joining 4 tables

Posted 13 August 2012 - 09:06 PM

I notice you';re using reference to db.id as well as db.ID. If you're using VB.NET, then I'm guessing you're using Windows, in which case there could be case sensitivity issues at play here. If it's a MySQL database, try enclosing all the table names and column names in backticks, like this:

SELECT `db`.`roomno`, `dbt`.`timee`...

Also, make sure your table and column names match between the query and the database. Some of those column names look like they could be misspelt, such as subjectss and dayy.