table join

[netJP12L]

Hi guys. i want join the results this table below with matching records of another table. How could i do it. I have tried using the right join on class table but seems like not getting the right results. could you hlep me joining the class table with all all those records are only in class table. Thanks select ucv.cf_value+', '+ucv2.cf_value as FullName from users u left join CUSTOM_FIELDS_VALUE ucv on ucv.cf_id=3 left join CUSTOM_FIELDS_VALUE ucv2 on ucv2.cf_id = 2 right join class on class.instructorName= ucv.cf_value+', '+ucv2.cf_value where u.uid=ucv.uid and u.uid=ucv2.uid order by ucv.cf_value+', '+ucv2.cf_value asc

[Mycroft Holmes]

Oh dear have you got a problem. Looks like you are using the instructors name as a key field for joining tables - WRONG. Each table should have an ID field (usually and int IDENTITY(1,1)) as the primary key and then a foreign key to maintain data integrity. Your join structure is wrong. A left join to UCV2 and THEN a right join the to class means that you will get records, wait I'm have no idea what you would get but it would be a mess. Take a look at this Visual Representation of SQL Joins[^] for some clarification

Never underestimate the power of human stupidity RAH