Thread: problem join

having problem joining these correctly:

schedule
- cal_id references calendar not null
- usr_id references users not null
= unique( calZ_id, usr_id )
- result_no not null

activity
- cal_id references calendar not null
- usr_id references users not null
= unique( cal_id, usr_id )
- from_ts timestamp not null

trying to join
- cal_id
- usr_id
- schedule.result_no (might be null)
- activity.from_ts (might be null)
where schedule.usr_id = activity.usr_id would result in one row

thanks for insight!

      
____________________________________________________________________________________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz 

chester c young escreveu:
> having problem joining these correctly:
> 
> schedule
> - cal_id references calendar not null
> - usr_id references users not null
> = unique( calZ_id, usr_id )
> - result_no not null
> 
> activity
> - cal_id references calendar not null
> - usr_id references users not null
> = unique( cal_id, usr_id )
> - from_ts timestamp not null
> 
> trying to join
> - cal_id
> - usr_id
> - schedule.result_no (might be null)
> - activity.from_ts (might be null)
> where schedule.usr_id = activity.usr_id would result in one row
> 



Try:
SELECT * FROM schedule FULL OUTER JOIN activity              USING (cal_id, usr_id) ....

Osvaldo