Hi Everyone,

I was just wondering what is the best and most efficient way of joining 2 tables together.

What i have is a category table and a opportunity table. The opportunities will be asigned to a category or multiple categories so i need to work out how to join the two without having duplicate opportunities. Do i need a table in between containing each unique id to assign them together?

Thanks

Tim

TDA

__________________
TDA

http://www.w3schools.com/sql/sql_join.asp

Look at Right Joins and Left Joins. And make sure you get the tables in the correct order for the joins to work properly.