Author Topic: Quick Question...Firebird SQL  (Read 5485 times)

0 Members and 2 Guests are viewing this topic.

mgpw4me@yahoo.com

  • Guest
Quick Question...Firebird SQL
« 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.   >:(

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Quick Question...Firebird SQL
« Reply #1 on: February 20, 2010, 03:14:25 am »
SELECT * FROM PEOPLE
INNER JOIN CAREER ON (PEOPLE."pid" = CAREER."pid")
                 
Gentlemen, you can’t fight in here! This is the War Room!