Not show the data in the query

[Frank Situmorang]

Hello,

I transfer the excel data to database, since I want bulit it's data base. I
found it that query will not show anything, if nothing filled in the other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.

 

[Allen Browne]

Use an outer join

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

 

[Frank Situmorang]

Allen, I have dobuble click the line, there is no option for OUTER Join, what
we have is

1. Only included rows when the joined filed from both tables are euqual
2. Included all records from "Jenis Kelamin". and only those records from
'Bukuangkby" when the joined fields are egual
3. Indclude all records from "Bukuangkby" and only those records from "Jenis
Kelamin" when the joined fields are equal

I do not know which one is outer joins.

We appreciate your help

Frank

 

[Allen Browne]

The first one is the INNER join.

The other 2 are the outer joins (LEFT and RIGHT.)
Choose which table you want to return all records from.

Then, as the article points out, be careful about criteria you use on the
other table.

 

[Frank Situmorang]

Thank you Allen, it's clearer to me now, sorry for my stupid question maybe
since my specialist in fact is in finance and accounting but I try to do by
slef strudy since 30 yrs ago I took basic languange course, and I want to
refresh my mind now and it seems it works by the help of all good friends in
this forum.

Again, thank you very much.