Do you mean...
SELECT
T.*
FROM
Tenders T
WHERE
(T.Date_Closing IS NULL)
or (T.Value IS NULL)
or ((T.Date_Closing BETWEEN DateA and DateB) and (T.Value IS NULL))
On Wed, Oct 17, 2012 at 7:47 AM, Nols Smit wrote:
> **
>
>
> Hi,
>
> I have a table, let's call it TENDERS. It has the follo
Try using aliases:
SELECT
SCHEDULE.DATE_TIME,
HOME_TEAM.TEAM as HomeTeamName,
AWAY_TEAM.TEAM as AwayTeamName
FROM
SCHEDULE
LEFT JOIN TEAMS HOME_TEAM ON SCHEDULE.HOME_TEAMID=HOME_TEAM.PRIMARYKEY
LEFT JOIN TEAMS AWAY_TEAM ON SCHEDULE.AWAY_TEAMID=AWAY_TEAM.PRIMARYKEY
On Wed, Oct 24, 2012
But this won't return rows for dates where there is no record in the source
table.
On Wed, Oct 24, 2012 at 6:02 PM, Leyne, Sean wrote:
> **
>
>
>
> > I have query which extract the sales per day from a table
> >
> > Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS
> > DAYNO, SU
I believe that the basic assumption that you have to put the database into
a quiescent state to get a consistent backup is incorrect. I always
thought that Firebird backups ran in a single long transaction meaning that
nothing committed after the backup starts can be seen by the backup.
Louis Kle
But LEFT OUTER JOIN may cause the optimizer to scan through the table for
which all rows are being included in physical order while the INNER JOIN
might cause a plan where rows are read based on a scan through an index. If
rows aren't being filtered out, I can see how this might speed up the query