Lines Matching full:join
446 "JOIN [raw_contact] AS [name_raw_contact] "
448 "LEFT JOIN [account] ON "
450 "LEFT JOIN [photo_files] ON "
498 "LEFT JOIN [account] ON "
500 "LEFT JOIN [photo_files] ON "
590 "JOIN [raw_contact] ON "
592 "JOIN [contact] ON ([contact].[id] = [raw_contact].[contact_id]) "
593 "JOIN [raw_contact] AS [name_raw_contact] ON "
595 "LEFT JOIN [account] ON "
597 "LEFT JOIN [contact_type] ON "
599 "LEFT JOIN [groups] ON "
602 "LEFT JOIN [photo_files] ON "
692 "JOIN [raw_contact] ON "
694 "JOIN [contact] ON "
696 "JOIN [raw_contact] AS [name_raw_contact] ON "
698 "LEFT JOIN [account] ON "
700 "LEFT JOIN [contact_data] ON "
702 "LEFT JOIN [contact_type] ON "
704 "LEFT JOIN [groups] ON "
707 "LEFT JOIN [photo_files] ON "
725 "LEFT JOIN [account] ON ([groups].[account_id] = [account].[id])";
783 "LEFT JOIN [contact] ON ([contact].[id] = [deleted_raw_contact].[contact_id]) "
784 "LEFT JOIN [raw_contact] AS [name_raw_contact] ON ([name_raw_contact].[id] = "
787 "LEFT JOIN [account] ON ([name_raw_contact].[account_id] = [account].[id]) "
788 "LEFT JOIN [photo_files] ON ([photo_files].[id] = [name_raw_contact].[photo_file_id]) ";