From: "Jonathan Gledhill" <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 1:01 PM
> 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. You will have to either: 1) Search the 4 tables one-by-one and also get 4 individual result tables. These 4 results you could store in a single table by doing some append. Watch out that the fields in the tables match! 2) Store all objects in the same single table and do your search there. This also require that the fields matches between the tables. What you are trying to do is beyond the nature of SQL. You may like to learn more about SQL. Lots of information is available through Google, so this is just one link: http://www.geocities.com/SiliconValley/Vista/2207/sql1.html Kind regards Uffe Kousgaard www.routeware.dk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9773
