Interbase 5.5 Left Join (easy question lots of points)
Posted on 2004-03-25
Ok I know this is a simple question, but after searching 4 or 5 interbase pdf files and google....
Can anyone please tell me how to do a LEFT JOIN in Interbase 5.5?
I am also using the old style SQL joins
select p.parentName, c.ChildName from Parent p, Child c where p.parent = c.parent;
I need to know the syntax to be used in the where clause?
I assigned so many point because I would like an answer within the next 30 minutes or so.