combine data from two tables

[SantoR]

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
.

 

[CJ_London]

do a left join on tableA to tableB. In the query builder, create the join, then right click on the join line and select join properties. Then select option 2

 

[SantoR]

thanks for the quick reply...CJ