I have 2 tables:
projmatl (master table)
job (detail table)
They have a 1:1 relationship in most cases. In some case there is no record in the job table that will join back projmatl. They should join on the following fields:
My resultset should be the total number of records and fields from projmatl and the job.job field if there is a record that joins back to the master table.
What would the sql be?