MAIL PROTECTED] cc:
ate.ny.us> Subject: RE: Problem with
Outer Join
Sent by:
[EMAIL PROTECTED]
08/22/2002 08:58
AM
Please respond
PROTECTED] cc:
ate.ny.us> Subject: RE: Problem with Outer Join
Sent by:
Aleem,
Your query should be:
SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
FROM A, B
WHERE to_char(year_date, 'dd-mm-')
= to_char(attend_date,'dd-mm-') (+)
The above says to return all records from the year_date table and , oh, by
the way, return any recor
Hi,
In our employee's attendance application the attendance data is stored in
table 'A' including employee ID and attendance date & time. Another table
'B' has one column with dates of current year (365 records). For the sake of
simplicity, other fields are ignored.
Table: A
Employee_ID