A
ali
I have 2 tables.
Table1: All new trades, (ID, Name, Amount, Remarks)
Table2: All trades from before till now (ID, Name, Amount, Remark).
---------------------------------------------------------------------
I'd like to :
Link these two tables to extract the new trades, meaning trades in table1
which got no record in table2.
--------------------------------------------------------------------
Note:
I have another query to update into table2 everyday.
Thanks a lot, dear experts !
Table1: All new trades, (ID, Name, Amount, Remarks)
Table2: All trades from before till now (ID, Name, Amount, Remark).
---------------------------------------------------------------------
I'd like to :
Link these two tables to extract the new trades, meaning trades in table1
which got no record in table2.
--------------------------------------------------------------------
Note:
I have another query to update into table2 everyday.
Thanks a lot, dear experts !