Assistance needed on query

[Ruslan Zasukhin]

On 14/5/07 1:43 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>>  SELECT competence_cards.recid, '' AS  'mycompetenceid',
>>                                ^^^^^
>>                               what Is this ?
> 
> That would be the table name. Since I am using a join I have 2 tables
> with recids and I suppose I need to fully qualify them in order to
> specify which of the two I want ?

Don't understand.

Can be

    SELECT f1
    SELECT f1 as 'alias'
    SELECT expr as 'alias'

But you have

    select '' as 'alias'

What means EMPTY single quotes?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]