Randy Shaw · Dec 27, 2017
Randy Shaw · Oct 14, 2017
I am not sure there is a logical way for those tables to be joined. But for syntax purposes here is a query that works although, as mentioned, illogically.
SELECT
* FROM (SELECT * FROM Sample.Employee e LEFT JOIN Sample.Company c ON c.ID=e.Company) g
JOIN Sample.Vendor v ON g.Company=v.Vendor
Randy Shaw · Dec 27, 2017
And my 2 cents ..........
WHERE
datediff(year,
todate(to_char(dgi.Birthdate,'YYYY')||':1','YYYY:MM'),
todate(to_char(current_date,'YYYY')||':1','YYYY:MM')
) >= 13
Followers:
Randy has no followers yet.
Following:
Randy has not followed anybody yet.
Global Masters badges:
Randy has no Global Masters badges yet.
ftp://ftp.intersys.com/pub/cache/odbc/