[Firebird-test] Problem with non joined queries

[Venelin D. <ve...@di...>]

    Hi,
    I can't fetch any records with this query:

SELECT
  M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
  R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
FROM pjmodule pjM, projects P, modules M, revision R
LEFT OUTER JOIN users U ON M.userid = U.userid
WHERE
  pjM.moduleid = 26
  AND pjM.projectid = 1
  AND P.projectid = pjM.projectid
  AND M.moduleid = pjM.moduleid
  AND R.moduleid = M.moduleid
ORDER BY
  R.version,
  R.revision,
  P.projectid

when I change previous one with this I have no problems

SELECT
  M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
  R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
FROM pjmodule pjM
JOIN projects P ON (P.projectid = pjM.projectid)
JOIN modules M ON (M.moduleid = pjM.moduleid)
JOIN revision R ON (R.moduleid = M.moduleid)
LEFT OUTER JOIN users U ON M.userid = U.userid
WHERE
  pjM.moduleid = 26
  AND pjM.projectid = 1
ORDER BY
  R.version,
  R.revision,
  P.projectid