Null Values

[viralbhatt]

Hello,

I have two tables called table1 and table2 with following fields:

Table1:
Name
NameId


Table2:
Name
NameID
Visits


where name and nameid is same but visit can me 0 to 230. name in table2 is
same as table2 but only showing visit 1 or higher. How can I make new table that can list all name, nameId and visits.

I can create new table but it shows only table2's record. so all I need is
table1 and table2 record if names are missing in table2 then put 0.

Viral

 

[neileg]

Change the join between the two tables. You have a type 1 join which returns only matching records. You need a left join which returns all the records from table1 and the matching records from table2.

 

[viralbhatt]

Thank you

Thank you for,

It's working

Viral