You are viewing limited content. For full access, please sign in.

Question

Question

How to Compare 2 SQL tables

Version 10 Forms

Updated July 12

asked on July 11 • Show version history

We have 2 tables each with three identical columns.

Date, vendor, cost.

We would like to have a SQL view to display rows that match. Then have forms highlight the matched rows as green and non matching rows as red.

Or perhaps use javascript.

Does anyone have any suggestions?

0 0

Replies

replied on July 12

SQL Inner Joins work great for returning matches and Left Joins where Table 2 fields are null for unmatched

https://www.w3schools.com/sql/sql_join.asp

You can use CSS in forms to change the colors of the lookup tables, attached to your views.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked July 11
Updated July 12
30 views