[khaledkamal]

how to join 2 rows in database by sql server
i made it by this code put it repete the same row

SELECT name,education_level,name_school,phone_home,mobile_student,mobile_home,addrees,name_pay,name_sbj
FROM students
 
FULL JOIN subjects
ON students.number =subjects.number

FULL JOIN payment
oN students.id_pay=payment.id_pay

where id_s=0

[e_i_pi]

Well, you're joining three tables there, and you're using FULL JOIN, which is the same as a LEFT and RIGHT JOIN at once. So, there's probably going to be a lot of rows returned that you're not after.

I'm not sure exactly what you require, but try this out:

SELECT
	name,
	education_level,
	name_school,
	phone_home,
	mobile_student,
	mobile_home,
	addrees,
	name_pay,
	name_sbj
FROM students
INNER JOIN subjects ON students.number =subjects.number
LEFT OUTER JOIN payment ON students.id_pay=payment.id_pay
WHERE id_s=0

This will generate a result set for all students that are in at least one subject, regardless of whether they have paid or not. Is that what you need?

[pnev]

I agree with Euler. LEFT JOIN or RIGHT JOIN is what you're looking for.