Yes Joiny thing indeed. That is what you need. However,, I wish I could help. Have not done one myself. but this always helps if you are using PHP/mysql. The manual can probably answer 90% of your questions... * * PHP Manual. www.php.net/manual * MySQL Manual: www.mysql.com/documentation/mysql/bychapter On Tuesday, October 28, 2003, at 09:06 PM, Paul Bennett wrote: > 'ello > I have a table with (among other things) 3 columns (int_area_1, > int_area_2, int_area_3) > > Is it possible to query the db to get the distinct values of all > these columns combined > (eg all the unique values from not just int_area_1, but from > int_area_2 and 3 as well) > ? > > I am envisioning I am going to have to do some kind of joiny thing but > I'm not sure how....:) > > Paul Bennett > > For your free report: "10 time-killing web development mistakes and > how to avoid them" > send an email to: > bennettpr at getresponse.com > or visit > http://www.clicksave.co.nz > > > > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester and > archives of thelist go to: http://lists.evolt.org Workers of the Web, > evolt !