Access/SQL - LEFT OUTER JOIN fails.

[JLCantara]

[RESOLVED] Access/SQL - LEFT OUTER JOIN fails.

Hi everyone,

I need a stored procedure that will lists all records of table A and those that match NutrNo of table B (see snapshot attached). Whatever I do, I get the result of a standard link!!!

Thanks,
JLCantara.

 

[JLCantara]

Hi Pat,

You are wright!!! Reading your post, I remembered doing it in the past but alas, I'm getting old...

You will notice in the link the usage of an inline table function since SP cannot be used in an SP?!?

IT IS A DESIGN FLAW in SQL.

Again, thank you very much!!!

JLCantara.

P.S. - How can I mark my post as resolved?