created join table instead of join statement. this is what sql actually defines