mohamedazmi
Posts: 13
|
| Posted: 04/26/2011, 8:37 PM |
|
how to select * that is null--
example
SELECT auto_desc, comp_desc, inhse_desc, macro_desc
FROM ((((((request INNER JOIN tbl_comp ON
request.req_com_id = tbl_comp.comp_id) INNER JOIN tbl_mont ON
request.req_autocad = tbl_auto.auto_id) INNER JOIN tbl_macro ON
request.req_macro = tbl_macro.macro_id) INNER JOIN tbl_inhse ON
request.req_inhse_apps = tbl_inhse.inhse_id
|
 |
 |
damian
Posts: 838
|
| Posted: 04/27/2011, 12:24 AM |
|
where fieldname IS NULL
or
where fieldname IS NOT NULL
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
ckroon
Posts: 869
|
| Posted: 04/27/2011, 10:54 PM |
|
I found that making a VIEW of the tables.. then joining the view to another table and using WHERE field IS NULL works well and keeps it simple.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
|
