Not specified

[Huan]

"SELECT job_id, job_title, posting_date, company_name " & _
"FROM job INNER JOIN company ON job.company_id = company.company_id " & _
"WHERE pending = 'yes' AND posting_date = NULL"

How I can find posting_date fields that value is NULL

IN the SQL Server Database postinf_date datatype is datetime the default value is <NULL> How I can use SQL query find posting_date is <NULL>


Please help me

[Scott]

do not specify posting_date = NULL. The correct syntax is: posting_date is null. So your example should be as follows:

&#34;SELECT job_id, job_title, posting_date, company_name &#34; & _
&#34;FROM job INNER JOIN company ON job.company_id = company.company_id &#34; & _
&#34;WHERE pending = &#39;yes&#39; AND posting_date is NULL&#34;



------------
Huan at 7/16/01 3:49:02 PM

&#34;SELECT job_id, job_title, posting_date, company_name &#34; & _
&#34;FROM job INNER JOIN company ON job.company_id = company.company_id &#34; & _
&#34;WHERE pending = &#39;yes&#39; AND posting_date = NULL&#34;

How I can find posting_date fields that value is NULL

IN the SQL Server Database postinf_date datatype is datetime the default value is <NULL> How I can use SQL query find posting_date is <NULL>


Please help me