Hi all, I have a problem with join which drive me crazy :
3 tables AM_GRUPPI, AM_SGRUPPI, AM_FIGURE
AM_GRUPPI 1--* AM_SGRUPPI 1--* AM_FIGURE
the follow query returns 28 records
SELECT
t0.ID, t0.CODICE_SPK,
t1.ID, t1.CODICE_SPK,
t2.ID, t2.ISARTICOLO
FROM AM_GRUPPI t0
the follow query returns 28 records
SELECT
t0.ID, t0.CODICE_SPK,
t1.ID, t1.CODICE_SPK,
t2.ID, t2.ISARTICOLO
FROM AM_GRUPPI t0 JOIN AM_SGRUPPI t1 ON t0.ID = t1.GRUPPO_ID
LEFT JOIN AM_FIGURE t2 ON t1.ID = t2.SGRUPPO_ID
WHERE t0.CODICE_SPK='27' and
Il 12/05/2014 22:09, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] ha scritto:
the follow query returns 28 records
SELECT
t0.ID, t0.CODICE_SPK,
t1.ID, t1.CODICE_SPK,
t2.ID, t2.ISARTICOLO
FROM AM_GRUPPI t0 JOIN AM_SGRUPPI t1 ON t0.ID = t1.GRUPPO_ID
LEFT JOIN AM_FIGURE t2
Hi Bhavbhuti,
I do not know the exact solution, but I'd say:
COALESCE(CAST(tPB.dBillDt AS TIMESTAMP), '') AS tDocDt
converts timestamp inside servers environment to a string - the
returning client receives a string and does not know about it's datatype
- yet does not a apply specific
I am a MSP for a large dental office that uses an application with a
Firebird DB. I've done a lot of database work in my life, but none with
firebird so I need a little help with the configurations. The office is
complaining of slowness and what we've done so far to help them will be
below. Keep
Hi,
Your database is not big but your settings are low. Change your FB server to
64bit and increase your dbbuffer or in fbconfig defaultdbcasche setting and use
superserver. Check your database data page size. I always set it to 16KB. Your
database utylize memory in this pattern:
Dbpage size