Sunday, 15 February 2015

c# - JOIN clause with WHERE -


I've got 3 courses, courses, courses, courses, courses and courses. Course Kaushatsheet is a junction table. I am trying to select those courses that are specially associated with the use of junction tables. This is my first time using a Jungle Table and the Joy Clause, I do not know how to know about it. If you can do something to help you, then it will be very appreciated 

  Get the public static course detailsSelect category (string category) {courseDetails details = new course description (); (OleDbConnection connection = getConnection ()) {string query = "select course name, course course name, course course of course, where live course on class = @ category course IED = Course category. Course" + "course course Course Course Category: ID = CourseCourse Category.CarsCIDIDIDID "; OLDIB COMMAND COMMANDMENT = New Oralbie Comund (query, connection); OlivebPameter Pump = New OliveP parameter ("@ course country", course Caribbean); Command.Parameters.Add (Children's car); Connection.Open (); OleDbDataReader Reader = command.ExecuteReader (); While (reader.Read ()) {courseDetails d = new courseDetails (); D.CourseName = reader ["course name"]. ToString (); D. Description = Reader ["Description"]. ToString (); Description = D; }} Return Details; }

I suggest you to understand how it works:

Then join the junction table with 

  course - or with the course category: Course C JOIN from  
  Course Question CC on CID = CC. Cosdie  
 Then join the CATEGORY from the junction table:  
  course from the course of course G course course category category category CCA on CID = Cc.CourseID Add cc.id = ccc.CourseCategoryID  
 to the course category cc then where the section:  
  the course of the course of the course. ID = CC Council coincidence ccc = ccc.courseCategoryID where the ccc = = category  
 
 I think the category is a specialty of the course category (always use Qualifiers code Will make it easy to read and understand). Finally, choose from the relationship you define: 
 
  select c.CourseName, c. Courses from course to coin course cocus ccc ccid ccid ccid cc.id = cc.courseid course cc cc.id = ccc ccccc c.ccc = cCategoryID ccccc = Html>
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)