Just an addendum to Bastien's post: You'll need MySql 4.0+ if you want to use UNION. > -----Original Message----- > From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx] > Sent: Wednesday, September 29, 2004 2:15 PM > To: mnikhil@xxxxxxxxxxxxx; php-db@xxxxxxxxxxxxx > Subject: RE: I have a query > > > > if the tables have the same structure, use the union operator > to query each > table separately and return it all in one result set > > select * from asset1 where asset_loc='heaven' > union > select * from asset2 where asset_loc='heaven' > union > select * from asset3 where asset_loc='heaven' > union > select * from asset4 where asset_loc='heaven' > union > select * from asset5 where asset_loc='heaven' > > bastien > > > > > >From: "Mulley, Nikhil" <mnikhil@xxxxxxxxxxxxx> > >To: <php-db@xxxxxxxxxxxxx> > >Subject: I have a query > >Date: Wed, 29 Sep 2004 23:19:31 +0530 > > > >I have a query regarding mysql and PHP ... > >here it is .... > >I know there is a field data exisiting in one of the tables > in the present > >database; > > > >I want to know whether there is any sql or PHP function with > which I can > >find out in which table the field data is present for example ..... > > > > > >I have database called asset > >in which 5 table are present namely > asset1,asset2,asset3,asset4,asset5... > > > >all the tables have the same schema structure and common > field names ,equal > >no of columns(but not the equal number of rows) > > > >I want to know ,in which table among the above is having a > particular field > >data for example ...the column name is asset_loc ( common > for all the > >tables,but no constraints ,no relation with other tables) > > > >I want to know if the asset_loc from any table has the data 'heaven' > > > >it should be something like this > >select * from asset1,asset2,asset3,asset4,asset5 where > asset_loc='heaven'; > > > > > > > >Thanks, waiting for a quick response ....from a great list. > > > >SELECT * FROM Linux_kids where Dis_Hard_Fans='Nikhil' ;-) > > > > > > _________________________________________________________________ > Take advantage of powerful junk e-mail filters built on > patented Microsoft(r) > SmartScreen Technology. > http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994& > DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines > Start enjoying all the benefits of MSN(r) Premium right now > and get the > first two months FREE*. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php