Personal Video Database

English => Support => Topic started by: mgpw4me@yahoo.com on February 20, 2010, 02:09:57 am

Title: Quick Question...Firebird SQL
Post by: mgpw4me@yahoo.com on February 20, 2010, 02:09:57 am

  $sql = "SELECT * FROM
                  (CAREER,PEOPLE)
                  where PEOPLE.pid = CAREER.pid";

This is wrong, somehow...but how?  I'm stumpted...not a database guy at all.   >:(

Title: Re: Quick Question...Firebird SQL
Post by: nostra on February 20, 2010, 03:14:25 am

SELECT * FROM PEOPLE
INNER JOIN CAREER ON (PEOPLE."pid" = CAREER."pid")