I have some code. I want to copy all columns from
but only one column which is called "Id_rodzajpracy" from
How could I modify red instruction to do inner join?
Code:
tabela_zrodlowa = "tblGoraZlecenia"
Code:
tabela_zdrodlooffset = "tblOffset"
How could I modify red instruction to do inner join?
Code:
Dim rec_GoraZlecenia As DAO.Recordset
Dim rec_GoraZlecenia2 As DAO.Recordset
Dim rec_GoraZlecenia3 As DAO.Recordset
Dim tabela_docelowa As String
Dim tabela_zrodlowa As String
Dim tabela_zdrodlooffset As String
Dim s As String
tabela_zrodlowa = "tblGoraZlecenia"
tabela_docelowa = "tblGoraZleceniaRobocze"
tabela_zdrodlooffset = "tblOffset"
Set rec_GoraZlecenia = dbs.OpenRecordset(tabela_docelowa, dbOpenDynaset)
[COLOR="Red"]Set rec_GoraZlecenia2 = dbs.OpenRecordset("SELECT * FROM [" & tabela_zrodlowa & "] WHERE ID_Zlecenia ='" & nrZlec & "'", dbOpenDynaset)[/COLOR]
KopiujRekord rec_GoraZlecenia, rec_GoraZlecenia2, False, id_nr