No video

Microsoft Access: The SQL statement could not be executed - ambiguous outer joins

  Рет қаралды 485

Lisa Friedrichsen

Lisa Friedrichsen

Күн бұрын

This short screencast explains why a query fails due to the error message "The SQL statement could not be executed because it contains ambiguous outer joins" as well as how to resolve the problem.
See all of Professor Lisa Friedrichsen's KZfaqs for Access, database, HTML, CSS, and JavaScript organized at: learncs.w3spaces.com
Thanks, Lisa Friedrichsen

Пікірлер: 4
@zoomingby
@zoomingby Ай бұрын
Thank you! This was really helpful in understanding this concept. Why I've been working with access for over three years without seeing this and related concepts explained before is beyond me. Subscribed!
@lfriedrichsen
@lfriedrichsen Ай бұрын
Thanks for the nice comment!! See all of my KZfaqs organized at learncs.w3spaces.com
@davb9514
@davb9514 2 ай бұрын
Thanks, help me out with a problem :)
@lfriedrichsen
@lfriedrichsen 2 ай бұрын
You are welcome! See all of my KZfaqs organized at learncs.w3spaces.com
Microsoft Access: Troubleshooting poor Access database application performance
4:28
Microsoft Access: Troubleshooting poor Access database application performance
Lisa Friedrichsen
Рет қаралды 514
Query Criteria for Numeric Fields in MS Access - Office 365
2:22
Query Criteria for Numeric Fields in MS Access - Office 365
Find Easy Solution
Рет қаралды 55 М.
Survival Skills: Steam Distiller for Dirty Water in Extreme Conditions. #survival #camping
00:38
Survival Skills: Steam Distiller for Dirty Water in Extreme Conditions. #survival #camping
Sergio Outdoors
Рет қаралды 50 МЛН
妈妈教育孩子却被父女联合赶出家门！太寒心！ #搞笑#funny#萌娃
00:52
妈妈教育孩子却被父女联合赶出家门！太寒心！ #搞笑#funny#萌娃
一只小妤宝
Рет қаралды 30 МЛН
لااا! هذه البرتقالة مزعجة جدًا #قصير
00:15
لااا! هذه البرتقالة مزعجة جدًا #قصير
One More Arabic
Рет қаралды 52 МЛН
Whoa
01:00
Whoa
Justin Flom
Рет қаралды 31 МЛН
MySQL SELF JOINS are ... ughhh
10:03
MySQL SELF JOINS are ... ughhh
Bro Code
Рет қаралды 59 М.
How to Make Multiple Relationship Joins to the Same Table in Microsoft Access
22:01
How to Make Multiple Relationship Joins to the Same Table in Microsoft Access
Computer Learning Zone
Рет қаралды 23 М.
Microsoft Access A to Z: Designing Table Relationships
10:40
Microsoft Access A to Z: Designing Table Relationships
Lisa Friedrichsen
Рет қаралды 66 М.
Microsoft Access: Analyzing table relationships in the Nutrition tracking template
9:01
Microsoft Access: Analyzing table relationships in the Nutrition tracking template
Lisa Friedrichsen
Рет қаралды 469
Microsoft Access A to Z: Finding orphan records using join properties
6:58
Microsoft Access A to Z: Finding orphan records using join properties
Lisa Friedrichsen
Рет қаралды 1,4 М.
Microsoft Access: Creating a Lookup table (breaking a single table into two related tables)
8:39
Microsoft Access: Creating a Lookup table (breaking a single table into two related tables)
Lisa Friedrichsen
Рет қаралды 620
Combine Records from Multiple Tables or Queries Together Using a Union Query in Microsoft Access
15:00
Combine Records from Multiple Tables or Queries Together Using a Union Query in Microsoft Access
Computer Learning Zone
Рет қаралды 78 М.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
6 SQL Joins you MUST know! (Animated + Practice)
Anton Putra
Рет қаралды 144 М.
Microsoft Access: Analyzing 1-to-many and many-to-many relationships using Students and Classes
4:54
Microsoft Access: Analyzing 1-to-many and many-to-many relationships using Students and Classes
Lisa Friedrichsen
Рет қаралды 401
Missing Records in Joined Queries. Show All Records in Microsoft Access with Outer Join (Left Join)
10:30
Missing Records in Joined Queries. Show All Records in Microsoft Access with Outer Join (Left Join)
Computer Learning Zone
Рет қаралды 10 М.
Survival Skills: Steam Distiller for Dirty Water in Extreme Conditions. #survival #camping
00:38
Survival Skills: Steam Distiller for Dirty Water in Extreme Conditions. #survival #camping
Sergio Outdoors
Рет қаралды 50 МЛН