Hello!
I am sure I a missing something, just unsure what :)
This is my query:
SELECT *
FROM (
SELECT EMP. ID, ( EMP.SURNAME||', '||EMP.FIRSTNAME ) FULL_NAME,
DEP.department_name DEPARTMENT, ( 0 ) _A
FROM EMPLOYEES EMP
LEFT OUTER JOIN DEPARTMENTS DEP ON DEP.ID = EMP.DEPARTMENTID
UNION
SELECT
I am sure I a missing something, just unsure what :)
This is my query:
SELECT *
FROM (
SELECT EMP. ID, ( EMP.SURNAME||', '||EMP.FIRSTNAME ) FULL_NAME,
DEP.department_name DEPARTMENT,
( 0 ) _A
FROM EMPLOYEES EMP LEFT
OUTER JOIN DEPARTMENTS DEP ON DEP.ID = EMP.DEPARTMENTID
On Sat, Mar 2, 2013 at 1:52 PM, Leyne, Sean s...@broadviewsoftware.comwrote:
( 0 ) _A
SQL Names (Column/Field/Alias/Table/Views/Functions) must start with an
Alpha character (99% sure this is by SQL standard).
As usual, Sean is exactly right. The standard does require that names
start
At 05:41 a.m. 3/03/2013, Andrea Raimondi wrote:
Hello!
I am sure I a missing something, just unsure what :)
This is my query:
SELECT *
FROM (
SELECT EMP. ID, ( EMP.SURNAME||', '||EMP.FIRSTNAME ) FULL_NAME,
DEP.department_name DEPARTMENT, ( 0 ) _A
FROM EMPLOYEES EMP
LEFT OUTER JOIN DEPARTMENTS
Hi All,
I am new to ASP.NET, but familier with Firebird.
I am in search of how to connect Firebird to ASP.NET 2010 web application (code
language I am using is C#). I am trying to create sample application to become
a familier with ASP.NET, I worked with Firebird using Delphi. I used