Assistance needed on query

[Bart Pietercil]

Hi never_sleeping one

On 14-mei-07, at 12:38, Ruslan Zasukhin wrote:

> On 14/5/07 1:29 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> since I cannot test my SQL in VStudio (SQL editor crashing when
>> trying to open), I hope somebody could help me out why the following
>> query would give me as VException
>>
>> "SEMANTIC ERROR".
>>
>> While I do understand that this probably means that there is an error
>> in the semantics of the query, it isnt all that helpfull
>>
>> This is the query giving me the problem:
>>
>  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 ?


Bart