hi
i have two master tables..no fields are common in those two tables that is one table contain all the colleges name and region and other table contain all the courses name,duration etc..but i want to display the result in a grid fashion like all the institute name and all courses they offered or not... if it is offered then yes otherwise no..
how to retrive the information?
Vijaya KadiyalaPosted Apr 8, 2008, 11:29 AM
If you dont have common field there is no way you can join.
First correct the Table design and then you can write the query.
Post the table design so that we can guide in right way to achieve your goal.
Thanks -- Vj
http://dotnetvj.blogspot.com
Blocked AccountPosted Mar 10, 2008, 1:29 AM
If there is no relation then how will u decide that , this college offering this course or not.
Send me your problem in more detail.