Two Questions on Database Query Builder

Andre Garzia soapdog at mac.com
Mon Jan 12 20:30:24 EST 2004


On Jan 12, 2004, at 8:40 AM, Jan Schenkel wrote:

> Have you tried ?  *grin*
> Just tried it here, and it seems to work just fine,
> allowing you to fetch fields from both tables when you
> link fields to the query.
>
>> 	Cheers, and thanks in advance.
>>
>> Andre Alves Garzia ð 2003 ð BRAZIL
>> http://www.soapdog.org
>>
>
> Hope this helped,
>
> Jan Schenkel.

	Jan,

Thanks for your help!

On trying it, yes I tried but there was a problem since both tables 
used the same field names so MySQL shouted that the query was ambigous, 
that was fixed, it was a problem with MySQL, SQL Query and me, nothing 
to do with revolution, but I was slow to understand.

Thanks Again
Cheers
Andre



>
Andre Garzia  2003
imac2 ibook p100 e uma torradeira....



More information about the use-livecode mailing list