i have 2 tables one having primary key and other having secondary key
TblA
pkey
info1
info2
TblB
pKey_Rk
info3
info4
i want a resultset having all the records present in tblA plus records in TblB (if present)
pkey----info1----info2----info3----info4
value---value---value---value---value
value---value---value---notpresent--notpresent
.
TblA
pkey
info1
info2
TblB
pKey_Rk
info3
info4
i want a resultset having all the records present in tblA plus records in TblB (if present)
pkey----info1----info2----info3----info4
value---value---value---value---value
value---value---value---notpresent--notpresent
.
Last edited: