On Sunday 04 July 2004 11:36 pm, bruce wrote:
> hi...
>
> i'm trying to figure out how to deal with joins
> (left/right)..
>
> i have the following test tbls...
>
> create table universityTBL(
> name varchar(50) not null default '',
> ID int(10) not null auto_increment,
> pr
Bruce:
The problem is that you have universityTBL listed twice in your list of
tables. Here is your statement, with numbers for each of the sources.
SELECT schoolTBL.name, universityTBL.name
FROM (1) universityTBL, (2) schoolTBL
LEFT JOIN (3) universityTBL ON schoolTBL.universityID =
university
