qry help

R

rum23

I have a projects table and a project type table

tblProjects: this table has project no, project name and projecttype fields.
Projecttype field is null for some of the projects.

tblProjectType: this table has ProjectTypeName and FriendlyName fields.

Now I want to get the list of all projects from tblProjects along with their
friendly name from the tblProjectType table. For the projects that have null
in the projecttype should return "null" as their friendly name.

How do I do this in SQL?

Thanks
 
M

Michel Walsh

SELECT ProjectTypeName, NZ( FriendlyName, "null")
FROM tableNameHere


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Form based on query opens slow 4
Slideshow with black border around it 0
Re-title multiple MS Project .mpp files at once 0
Adding sequence numbers to paragraphs 0
Proposal template with removable sections 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Weekly Report 2

Top