[thelist] [sql] selecting multiple distinct columns

[Joshua Hmielowski]

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 !