Personal Video Database
News:
Home
Screenshots
Download
Forum
Search
Donate
Login
Register
Русский
Personal Video Database
»
English
»
Support
(Moderators:
rick.ca
,
Ivek23
) »
Quick Question...Firebird SQL
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: Quick Question...Firebird SQL (Read 4226 times)
0 Members and 1 Guest 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.
Logged
nostra
Administrator
Posts: 2852
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")
Logged
Gentlemen, you can’t fight in here! This is the War Room!
Print
Pages: [
1
]
Go Up
« previous
next »
Personal Video Database
»
English
»
Support
(Moderators:
rick.ca
,
Ivek23
) »
Quick Question...Firebird SQL