Hi
Wonder if one of you guru's could help me with this relatively simple
query!
I'm trying to search through several tables called VALVES, HYDRANTS,
METERS and PRV. They all have one field in common called ASSET_ID in
which a unique id number is held.
What i want to do is through one button, search for an input asset id
number through all these four tables at once.
I'm able to make it work through a seperate mbx for each table, but
this is a nuisance if i need to update anything and I tried to write
something that would search all 4 tables in one go. I assumed (probably
wrongly) that as i'm not bothered about joining these tables in any way
and that as they all contain an ASSET_ID field that i could just search
them all at once, like this
**************
SUB asset_search
DIM assetid AS STRING
DIALOG
TITLE "Asset ID Search"
CONTROL STATICTEXT
TITLE "Enter Asset ID to Search For"
CONTROL EDITTEXT
INTO assetid
CONTROL OKBUTTON
CONTROL CANCELBUTTON
SELECT *
FROM VALVES,HYDRANTS,METERS,PRV
WHERE ASSET_ID = assetid
INTO assetidresult
BROWSE *
FROM assetidresult
END SUB asset_search
**************
But when i run the program, i get warned that there is "No Join
Specified Between Tables VALVES and HYDRANTS, invalid join in WHERE
clause".
I'm now stumped and cant seem to find an answer in the books... Could
anyone suggest how i could search these tables in one go?
Thanks
Jonathan
**********************************************************************
CONFIDENTIALITY
The information contained in this message and any attachments
are intended solely for the use of the individual or entity to whom
they are addressed. It may contain privileged or confidential
information. If you are not the intended recipient you must not
copy, distribute or take any action in reliance on it. If you have
received this e-mail in error please notify the sender. Thank You
This e-mail message has been swept by MIMEsweeper for the
presence of known computer viruses.
**********************************************************************
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9770
