Hello friends,
My db has two main tables (table1 and table2).
Table1 gets its records periodically from a text file that I import and that I cannot change.
Table2 is used to store new data, like changes in phone number, email, addresses, etc. I use this table like an historical log and need to verify the changes in the long term.
I would like now to create a query that returns from Table2 only fields with data. It should not show blank fields.
Appreciate any help. Thank you
My db has two main tables (table1 and table2).
Table1 gets its records periodically from a text file that I import and that I cannot change.
Table2 is used to store new data, like changes in phone number, email, addresses, etc. I use this table like an historical log and need to verify the changes in the long term.
I would like now to create a query that returns from Table2 only fields with data. It should not show blank fields.
Appreciate any help. Thank you