MySQL joined select

[Bob Sneidar]

Any columns you define in the select statement will be in the returned data. You do not have to retrieve a column to use it in the select statement. This works:

select zip from addresses where state = "CA"

Besides that, I do not know what you mean by "hide". Hide from what? Your user interface? If you are using a datagrid, you can simply set the dgprop["columns"] of the datagrid to the ones you want to see, excluding the ones you want to hide. The data will still be there and can be referenced like all the other data, but it won't show in the datagrid. 

Bob


On Mar 20, 2012, at 2:20 AM, Marek Reichenbach wrote:

> Thanks for the replies.
> I've made it workin, but I wanna add something else:
> 
> So the question in SQL is:
> 
> Maybe there is a way to hide columns it the result, like:
> SELECT car_nr, model, travel_days FROM table1,table2 WHERE number <> 414
> AND (car_nr > truck_nr) from transport;
> and show only result of the colums travel_days, but ONLY on*
> **separate* columns
> and  HIDE OTHER COLUMNS.
> 
> I've posted here more detailed:
> http://forums.runrev.com/viewtopic.php?f=12&t=11426&p=53702#p53702
> Help please...
> 
> On 20 March 2012 01:09, Pete <pete at mollysrevenge.com> wrote:
> 
>> Seems like either Peter or Mark's solution would be a lot better than
>> trying to do it with an SQL SELECT, but I'm also not sure of what Marek is
>> trying to achieve - seems strange to want to replace all the numbers with
>> plus signs.  Maybe he wants a floating plus sign at the start of the
>> number, dunno.
>> Pete
>> 
>> On Mon, Mar 19, 2012 at 3:50 PM, Peter M. Brigham, MD <pmbrig at gmail.com
>>> wrote:
>> 
>>> repeat with n = 1 to length(tInput)
>>>  if char n of tInput is a number
>>>  then put "+" into char n of tInput
>>>  else put "-" into char n of tInput
>>> end repeat
>>> 
>>> Or am I missing something?
>>> 
>>> -- Peter
>>> 
>>> Peter M. Brigham
>>> pmbrig at gmail.com
>>> http://home.comcast.net/~pmbrig
>>> 
>>> On Mar 19, 2012, at 5:15 PM, Pete wrote:
>>> 
>>>> I wonder if there might be a less ugly way to do this in LC instead of
>>>> SQL...
>>>> Pete
>>>> 
>>>> On Mon, Mar 19, 2012 at 2:04 PM, Marek <reichenbach.marek at gmail.com>
>>> wrote:
>>>> 
>>>>> Thanks a lot! That helped me a lot man.
>>>>> 
>>>>> Marek Reichenbach
>>>>> 
>>>>> On 2012 Kov. 19, at 19:29, Ken Ray <kray at sonsothunder.com> wrote:
>>>>> 
>>>>>> 
>>>>>> On Mar 19, 2012, at 3:44 AM, Marek Reichenbach wrote:
>>>>>>> when i get for example: 1234567 -> i should get result +++++++,
>>> 123-56-
>>>>> I
>>>>>>> would get +++-++- .
>>>>>> 
>>>>>> The only way I know is kind of ugly, requiring seven nested REPLACE
>>>>> statements:
>>>>>> 
>>>>>> SELECT
>>>>> 
>>> 
>> REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("123-56-","1","+"),"2","+"),"3","+"),"4","+"),"5","+"),"6","+"),"7","+")
>>>>>> 
>>>>>> This would return:
>>>>>> 
>>>>>> +++-++-
>>>>>> 
>>>>>> 
>>>>>> Ken Ray
>>>>>> Sons of Thunder Software, Inc.
>>>>>> Email: kray at sonsothunder.com
>>>>>> Web Site: http://www.sonsothunder.com/
>>>>>> 
>>>>>> _______________________________________________
>>>>>> use-livecode mailing list
>>>>>> use-livecode at lists.runrev.com
>>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>> subscription preferences:
>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>> 
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>> subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>> 
>>>>> 
>>>> 
>>>> 
>>>> --
>>>> Pete
>>>> Molly's Revenge <http://www.mollysrevenge.com>
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>> 
>> 
>> --
>> Pete
>> Molly's Revenge <http://www.mollysrevenge.com>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode