join with no ID or NULL 1

[gatetec]

I have demo & visit tables.
But, not all client IDs are on both tables.
I want to return all of records on tbl Visit and then join to tbl Demo if Client IDs exist on both tables.

select d.ClientNo, d.ClientFName, d.ClientLName, v.VisitDate
from demo d, Visit v
where d.ClientNo= v.ClientNoVisit
order by d.ClientLName, v.VisitDate

thx much

 

[RiverGuy]

Use an outer join.

SELECT d.ClientNo, d.ClientFName, d.ClientLName, v.VisitDate
FROM Visit v
LEFT OUTER JOIN Demo d
ON v.ClientNoVisit = d.ClientNo
ORDER BY d.ClientName, v.VisitDate

 

[SQLDenis]

faq183-4785

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[gatetec]

thx so much!