This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hello,
I would like to return all rows from "Logins" which are not present in "tbl_LoginIdCount"
It's just that I run this once and insert into compute."tbl_LoginIdCount"
but then when I run the same query again the select still returns the same rows and does not see tha tthose rows are already in tbl_LoginIdCount
select
CURRENT_DATE , count(fl."LoginId"), fl."LatestCode"
from
"Logins" as fl
left join "tbl_LoginIdCount" as lc on date(fl."LoginTimestamp") = lc."Date" and fl."LatestCode" = lc."Code"
WHERE
lc."Date" is NULL and lc."Code" is null
group by
fl."LatestCode";
For type of question, we recommend that you post CREATE TABLE statements for your tables and INSERT statements with sample data, enough to illustrate all angles of the problem. We also like to see the expected results given the test data.
This helps to clarify your question, and it makes it easy to copy and paste into a query window to develop a tested solution.
Beware that any solution you get here is likely to be for SQL Server. The appearance of CURRENT_DATE in your query, makes me believe that you are running something else And in that case, it may be better to find a forum dedicated to your product.
Why do you JOIN on column "LoginTimestamp"? If LoginTimestamp changes the JOIN fails and returns the customer again; remove it.
That is because loginTimestamp is new for each day and each day can have a separate code
Hi @arkiboys
It is recommended that you provide CREATE TABLE statements and INSERT statements, just the key columns and some sample records, in order to reproduce the issue and test.