Here's the query to cover your first request.

Hi Jeff,

Using the same test data I provided I wonder if you could help me build on your code to achieve an additional outcome.

Here's the query to cover your first request.

Here's the query to cover your first request.

Here's the query to cover your first request.

Hi Jeff,

Using the same test data I provided I wonder if you could help me build on your code to achieve an additional outcome.

First, really nice job on providing "Readily Consumable Data" AND it actually works without error! 😀

HoF

Can you provide an example against the table I provided.

thanks.

Thanks got it.

Cheers

Hi Jeff,

I do like this:

SELECT circuits.name AS circuit_name
, circuits.location
, circuits.country
, r.name AS race_name
, r.round
FROM dbo.circuits
LEFT OUTER JOIN (SELECT *
FROM dbo.races
WHERE race_year = 2009
) r ON r.circuit_id =...

Grant, sorry to be going on about this.

But just to be clear, are you saying that if not for the fact that I'm working with a OUTER JOIN everything would...

Perfect Ed

For my educational purposes, can you let me know where the following doesn't work:

SELECT
circuits.name AS circuit_name
,circuits.location
,circuits.country
,races.name AS race_name
,races.round
FROM dbo.circuits
LEFT OUTER JOIN dbo.races
ON circuits.circuit_id = races.circuit_id
AND races.race_year...

Hi Grant, can you give an example please.

Johan, thanks for the detailed explanation. However, the question still remains, how can I achieve the result without creating a derived table or...

• This reply was modified 2 years, 2 months ago by  carlton 84646. Reason: update

So, should I always write the code before doing the join for example doing the following will get me the right result:

First create tables / views

CREATE VIEW...

I just learned something today

Because you use "AND races.race_year = 2019" you turn your query result into the results of an inner join !

Thanks