Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
All records from one table and matching from other?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00603273
Message ID:
00604077
Vues:
27
This message has been marked as the solution to the initial question of the thread.
Hi Kirk,
move your where condition into join clause, so your query looks like this:

SELECT dbo.costatus.statusid,dbo.coStatus.statusdesc,
dbo.coPatStatus.statustime
FROM dbo.coStatus LEFT OUTER JOIN
dbo.coPatStatus ON dbo.coStatus.statusid = dbo.coPatStatus.statusid
and coPatStatus.meetingnumber=1

It loks like SQL engine executes where clause over the results and join condition over the source tables.

My firm is specialized in VFP and SQL tecnology. We are Microsoft Certified Partners with more than 5+ MCP/MCSD in VFP/SQL.,
We develop database applications mainly with Visual FoxPro 6.0/7.0 - front-end & web and SQL Server 7.0/2000 back-end applications. Visual Bsic we use to create ActiveX controls, which are not available in VFP. Visual C++ we use to create drivers with printers, bar-code readers, scales, etc. We have developed Visual FoxPro technology - the same VFP6.0/7.0 front-end to work either with DBF's or with SQL Server7.0/2000 back-end.
If you need more help or if we can subcontract you welcome.
Venelina Jordanova

Outsourcing IT Services Ltd.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform