Sql query -Results from 2 tables
Hi,
I need to write a query which checks whether a string is not present in table1 ,then look for it in table2.
sql1: SQL = "SELECT FormTable FROM " & TABForms WHERE " & ctUcase & "(FORMTABLE) LIKE " & (CalcTable.ToUpper & WildChr, ctText)
if FormTable does not exists in FormTable then check it in Usertable
sql2: SQL = " SELECT table_name FROM user_tables where table_name LIKE " & (CalcTable.ToUpper & WildChr, ctText)
Any help appreciated.
I need to write a query which checks whether a string is not present in table1 ,then look for it in table2.
sql1: SQL = "SELECT FormTable FROM " & TABForms WHERE " & ctUcase & "(FORMTABLE) LIKE " & (CalcTable.ToUpper & WildChr, ctText)
if FormTable does not exists in FormTable then check it in Usertable
sql2: SQL = " SELECT table_name FROM user_tables where table_name LIKE " & (CalcTable.ToUpper & WildChr, ctText)
Any help appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.