Pals,
I love this site with a passion.
Again now i need to know how i can relate different tables together using SQL database
with different field.
Thank you for your responses.
ibpet11 0 Newbie Poster
adam_k 239 Master Poster
Relate is a bit too generic for me. Can you please describe what you are trying to accomplish? Do you need a foreign key or a join ?
sneha_07 0 Newbie Poster
relationship acn be established by applying various join like natural join equijoin , non equi join outer join, inner join but depends on what kind of relationship is needed
another answer could be the tables can also be related by means of applying ric i.e refrential integrity by foregin key and primay key relationship
so be specific what kinda relationship you want
ibpet11 0 Newbie Poster
Yes I wanted Foreign Key and Primary Key code or tutorial in order to relate my tables together.
Bless you all for your assistance.
adam_k 239 Master Poster
Read here: http://www.w3schools.com/sql/sql_foreignkey.asp and here: http://msdn.microsoft.com/en-us/library/aa933117(v=sql.80).aspx (don't miss the See Also links in the bottom of the msdn article)
sneha_07 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.