suvo.kundu (1/12/2013)

---

in my table i have the records like

Id Record1 Record2 Level gid
1 testRec1 testRec2 0 1
2 testRec11 testRec22 0 2
3 testRec111 testRec222 0 3
4 testRec111 testRec2222 0 4
5 newtestRec newtestRec2 1 1

I want to show records like
Id OldRecord1 NewRecord1 OldRecord2 NewRecord2
1 testRec1 newtestRec1 testRec2 newtestRec2
2 testRec11 NoNewRecord testRec22 NoNewRecord
3 testRec22 NoNewRecord testRec33 NoNewRecord
4 testRec33 NoNewRecord testRec33 NoNewRecord

actually i have 2 querys
this is for old record
select * from tablename where level=0
this is for New record
select * from tablename where level=1

I want to merge this into a single record set as old and new..plz help

SELECT *
	FROM tablename old
		INNER JOIN tablename new
			ON old.id = new.id
	WHERE old.LEVEL = 0
		AND new.LEVEL = 1;