[thelist] [sql] selecting multiple distinct columns
Joshua Hmielowski
jhmielowski at comcast.net
Tue Oct 28 23:41:27 CST 2003
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 !
More information about the thelist
mailing list