two tables connect....

selamiduvar · October 27th, 2006, 05:08 AM

hi,
i have 2 tables.this are kayitt and hprogram.i want connect to that tables.but i have rows not in kayit tables and in hprogram table rows.so just not both of hprogram and kayit rocors + hprogram recors.

exp:Set rs22 = db22.OpenRecordset("select hprogram.giris,hprogram.cikis,kayit.adisoyadi,kayi t.tarih,kayit.gun,kayit.girissaati,kayit.cikissaat i from hprogram,kayit where (kayit.kartno = hprogram.kartno) and (kayit.gun = hprogram.gun) and (kayit.tarih = '" & Label4.Caption & "') order by bolumu,kayit.adisoyadi ")

this codes run only have in two tables same rocords.but i know there are relations records in hprogram table.

please help
thank for helps

gbianchi · October 27th, 2006, 08:55 AM

hi there...

first of all i'm trying to figure this out ;)

anyway.. are you sure you have related records?? can we see an example?? most probably that if you take out this clause (kayit.tarih = '" & Label4.Caption & "') it will work...

HTH

Gonzalo

zizo2120 · April 3rd, 2007, 04:11 AM

thanks for help him gbianchi

BrianWren · April 3rd, 2007, 12:37 PM

I think this is:

I have 2 tables, "kayitt" and "hprogram."

I want to open a recordset containing data from both of these tables at the same time, but I have rows in hprogram with no matching records in kayit.

Â¿so just not both of hprogram and kayit rocors + hprogram recors.?

example:

Code:

    Set rs22 = db22.OpenRecordset("SELECT hprogram.giris,  hprogram.cikis,           " & _
                                  "       kayit.adisoyadi, kayit.tarih,              " & _
                                  "       kayit.gun,       kayit.girissaati,         " & _
                                  "       kayit.cikissaati                           " & _
                                  "FROM   hprogram, kayit                            " & _
                                  "WHERE  (kayit.kartno = hprogram.kartno)           " & _
                                  "  AND  (kayit.gun    = hprogram.gun)              " & _
                                  "  AND  (kayit.tarih   = '" & Label4.Caption & "') " & _
                                  "ORDER BY bolumu, kayit.adisoyadi                  ")

This code runs successfully only when I have matching records in both tables.

But there are cases where I know there relationed records in hprogram, though the relationship is not one to one.

Selamiduvar: What is the database management system (Oracle, SQL Server, Access)?

gbianchi · April 3rd, 2007, 12:40 PM

this thread is 6 moths old!!! :p

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========