I'm having a hard time figuring out how to create a query with a sepcific calculated column. Hard to explain so I will give an example.
Let's say I have these two tables:
Table A
Server Name OS row1 AIX ROW2 Linux RoW3 AIX row4 Solaris rOw5 AIX
Table B
I want to create a query that will show all rows and columns from "Table A" with a calculated column that says "Yes" or "No" if that row's "Server Name" is in "Table B". The tricky part is that the "Server Name" from "Table A" may be a sub-string of "Server Name" of "Table B".
Server Name row1 hi_row2 row_this row_that row3 row5
Desired Output Table
Server Name OS In Table B row1 AIX yes ROW2 Linux yes RoW3 AIX yes row4 Solaris no rOw5 AIX yes