My own problem

Question

My own problem - I have the table (course) and the another(training). In course table- id no coursecode ..... In training table - idno name  nationality ...... I want to retrieve the number(count) of coursecode which is in same id no and the nationality will be American. The number of coursecode should be less than 2. I want to implement this by LINQ statement. If you want to help me kindly help me. Thanks a lot :-)

Asp.Net Hein · Answer

The number of coursecode should be less than 2. This is the main part that I have problem. Not the retrieving part. I cannot check (less than). (<) is cannot use in joining tables.

Bhushan Bhasme · Answer

var dealercontacts = from course in Course join Tr in Training on course.IdNo equals Tr. IDNo where tr.Nationality='American' select count(*); Hope This Might Help You

Asp.Net Hein · Answer

In Course Table -Idno. -Coursecode and other information In training table -Idno. -name -Nationality and other information Other infomation is not important to retrieve........

Upendra Pratap Shahi · Answer

Kindly give a snapshot of table structure..

Bhushan Bhasme · Answer

Can You please give your table structure in details?

Sakthikumar Thanavel · Answer

select idnocount(idno) from trainningtable where nationality='american' group by idno