밑의 2개의 T-SQL문을 ANSI SQL문으로 고칠려면 어떻게 해야 되죠?

첫번째



SELECT contact_sid,

last_name,

first_name,

middle_name,

last_name + first_name Contactfullname, /* <==이부분 */

title

FROM crm_contact



두번째 (연산자 : *=, =*)

SELECT ubiz_note.note_sid,

ubiz_note.item_category,

ubiz_note.item_sid,

ubiz_note.company_sid,

ubiz_note.step_id,

ubiz_note.seq,

ubiz_note.register_uid,

ubiz_note.register_date,

ubiz_note.update_uid,

ubiz_note.update_date,

ubiz_note.note_type,

ubiz_note.app_name,

ubiz_note.is_merge,

ubiz_note.contact_sid,

ubiz_note.description,

ubiz_note.file_name,

ubiz_note.note_category_cat_code,

ubiz_note.note_type_cat_code,

ubiz_text.attachment,

ubiz_company.name

FROM ubiz_note,

ubiz_text,

ubiz_company

WHERE (ubiz_text.note_sid =* ubiz_note.note_sid) and /* <==이부분 */

(ubiz_company.company_sid =* ubiz_note.company_sid) and/*<=이부분*/

(ubiz_note.item_sid = :case_sid) and

(ubiz_note.item_category = 'CASE')