[thelist] Really weird ASP problem

rudy r937 at interlog.com
Thu Jan 24 15:29:01 CST 2002


> If this really is your query, it's missing "INNER JOIN" and "ON"
> clauses.

hi tab

the query uses the "old school" table list syntax for an inner join

  SELECT b.name, b.email
       , bp.bpname
    FROM board b
       , board_position bp
   WHERE b.position=bp.id
     and b.chapter='99999'

the join condition is  b.position=bp.id  which would be in the ON clause
using the INNER JOIN syntax


rudy




More information about the thelist mailing list