>NO NO NO!!!!
>
>No foreign keys here. Those would be.. well foreign.
>No, we are lucky we have primary keys.
>
>Don't get me started!
Did you understand Mark's response. You need to provide both sides of the join condition equation just as you do when the relationship between tables is done using the WHERE clause.