Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Wols Lists
> Sent: Thursday, August 19, 2010 7:07 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] SQL field name issue.
>
> On 19/08/10 19:49, Geo
r.u2ug.org] On Behalf Of Wols Lists
>> Sent: Thursday, August 19, 2010 1:09 PM
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] SQL field name issue.
>>
>> On 19/08/10 05:20, Kevin King wrote:
>>> What about creating a view against the table and using
r.u2ug.org] On Behalf Of Wols Lists
> Sent: Thursday, August 19, 2010 1:09 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] SQL field name issue.
>
> On 19/08/10 05:20, Kevin King wrote:
> > What about creating a view against the table and using the view in
> your
On 19/08/10 05:20, Kevin King wrote:
> What about creating a view against the table and using the view in your
> join?
Actually, what I think he should do is create the three sub-fields as
individual fields, then declare a virtual field in your view as
"U2-Key", and also make those three fields a
What about creating a view against the table and using the view in your
join?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I'm setting up a mysql database based on some of our UV data.
Is there a way to create a field in MySQL that is a subfield?
For instance I have a field CID for customer ID, which is a superkey based on 3
pieces
I have another file which has a key of "FILE-###" where the ### is the first 3
chara